#### Calculating difference on Pivot Table Totals

```I have a pivot Table as follows

Region  State  jan  Feb ... Columm
North    NY      1      5
NJ      5      1
North Total     6       6

South   FL       2       6
GA       6       2
South Total     8       8

Grand Total     14      14

I would like to change the display of Grand total to show the difference
between the region as follows

Grand total difference (2)  (2)

Any help on this is greatly appreciated.

```
 0
PSM (3)
1/13/2006 3:37:02 AM
excel.misc 78881 articles. 5 followers.

0 Replies
438 Views

Similar Articles

[PageSpeed] 42

Similar Artilces:

2003 Excel Pivot table data selection
I am currently trying to create a PT but my source data is more than the 65k row limit. Can you create a PT using source data from 2 worksheets and if so, How? ...

calculate back dates
Hi is there a way to figure out a date 9 months previous to a date? eg. I have an install date of 12/02/10, is there a way or a formula that can count back 9 months from that install date? (they need to be weekdays) thanks very much Just use the Date function, as in: =Date(year(a1),month(a1)-9,day(a1)) Regards, Fred "sonia" <sonia@discussions.microsoft.com> wrote in message news:63DDCF12-C093-4532-B71C-2FB9112A47B8@microsoft.com... > Hi > > is there a way to figure out a date 9 months previous to a date? > > eg. I have an install date ...

Calculating a rank of scores
In the file attatched, I am needing a formula or any other kind of way to calculate the rank of each person with the set of scores. Eg. For "Person 6", I am needing a "1" to be displayed next to their name in column B to show that they are ranked number 1, BUT, if you were to change their score in column C, a different rank should be displayed, accordingly to the other 9 people in the range. I require a way to display the correct rank for each person next to their name. If anyone can help, it would be appreciated greatly. Cheers :D Attachment filename: r...

Pivot Tables #2
I am trying to format a pivot table with different rows of data. Attached is a copy of the current report, done in Crystal (it takes way to long). Is there a way to format a pivot table in Excel like this? Hi no file attached. BUT in this NG please do NOT attach files. Most people won't open them anyway. Try to explain in plain text what you're trying to achieve -- Regards Frank Kabel Frankfurt, Germany Richard E. Van Daele, Jr. wrote: > I am trying to format a pivot table with different rows of data. > Attached is a copy of the current report, done in Crystal (it tak...

Pivot Table Filter values
Is there a way to "read" what values you have selected for a Pivot Table filter in Excel-07? I have Report Filter(s) where I may select multiple values for any given filter. Being that this is a Report Filter, the values are not displayed in the data. For instance, say I have a Report Filter which contains 12 months (Jan - Dec). If I select Jan, Feb & Mar in this filter, the pivot table then reflects this data. However, short of clicking the drop down to see which items I've selected, I have no way of knowing what months are being displayed. I just want to be able to ...

Copy Specific Values from Table to Report
I don't know if this is the proper group to post this message into, but I'll start here and see what happens. To try and "simply" explain my request...... I know this can be done, as I've seen the results, but I can't figure out how to do it. I want to use the Report function of Access to create printed forms. I would have different reports, named A, B, C, D, and E for this example. The information I want to have printed on the report(s) comes from one specific table. On report "A" I want to have the values printed that are in rows 2,3, and 5 of "col...

Difference in Times
This is my first post so hello everyone and thankyou in advance for any assistance you can provide. The diffuclty I am having is as follows: I have a spreadsheet containing two times 8:45 and 9:45 I need to find the difference in the two times as a decimal but also as a fraction of an hour.. for these times the answer I need is 0.25 not 0.15. i.e. a quarter of an hour Can anyone help? -- bcbjork ------------------------------------------------------------------------ bcbjork's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26665 View this thread: http://...

"intersect" 2 slightly-different worksheets
Hello, All! I think this 'problem' requires a pretty simple solution; I just don't know what! Say you've got 2 worksheets, one w/ 50 rows and 6 columns, all relating to employee data (e.g., col headings like 'employee name', 'date of hire', 'hair color', and 3 other cols), and then a much longer sheet, with 500 rows, and 7 columns relating to employee data--6 of those cols being the same headings as the much-smaller sheet, but in addition the larger "master" sheet also has a column called "employee I.D. number", containing unique numb...

INSERT a Table (32 items) into another Table
Hi, I have a form with a subform. The subform is linked parent to child. The subform has a field that has a combo box. From the combo there are two choices. On the after update if the selcetion is equal too "INSERT ALL ITEMS - 32 LINES" the idea is to take the contents of a separate table line by line and insert into the subform / subtable. I Have the following code If Me!cboProject_Notes.Column(0) = "INSERT ALL CHOICES - 32 LINES" Then 'do the input from the table tblProjectNotes_Default Set db = CurrentDb Set rst = db.OpenRecordset(&q...

Forwarding Table
Hi, Im trying to integrate Exchange 2003 and a Unix based/type system. I can get the users on the Unix box to send mail out and the can rcv mail locally from the exchange box. However, there apparently is a table that can be built in exchange that will modify the unix users account (outgoing message) and add the correct domain to the e-mail address. Unix User sending mail: <user>@mail.domain.org I need exchange to strip the mail. off so the a user outside this facility can reply back. I also need exchange to forward that reply back to the unix box. Any ideas? Thanks, Dan ...

content in different language in Outlook
i had an outlook in a different language installed a while ago and since then it was uninstalled however the settings are still there as the new outlook shows main folders Incoming Mail, Outgoing Mail in different language. How can i correct this? k_dow <kdow@discussions.microsoft.com> wrote: > i had an outlook in a different language installed a while ago and > since then it was uninstalled however the settings are still there as > the new outlook shows main folders Incoming Mail, Outgoing Mail in > different language. How can i correct this? Try starting Outlook onc...

print of report is different than preview
I downloaded How to skip used mailing labels and print duplicates in Access 2002. It seems to be working fine until I try to print. It then prints from the first label and not as the preview showed. This is driving me buggy. What am I missing? The knoweldgebase article you referred to works for a single-page report. Provided you reset things in the Report Header's events, it should also work for printing (provided you print from the first page.) However, it does not work if you are printing reports that spill over onto several pages, unless you actually print all the pages. This i...

Highlight duplicates/groups different colors
Hi i want to show , different color for each group i have 2003 excel can i use conditional formatting? 123 green 123 green 456 red 456 red 888 green 999 red 999 red I assume that your data is in Column-A. Place the cursor in A1 cell and press Cntrl+Spacebar. Now the total column-A will be getting selected and the A1 will be the Active cell (Active Cell will have a white Background after selection). Format>>Conditional Formatting>>Condition 1>>Formula Is>> =3DCOUNTIF(A:A,A1)=3D1 Then Click the Format command button and choose your desired Font and Pattern colour. T...

Customizing for two different companies
I need to make customizations for two differnt companies (one is a subsidary, other is parent). I created a business unit in CRM for each comapny. How do I customizations for one company and different ones for the other company? How do I tell CRM that I want to change, for example, fields on the contact screen for the parent company, and not for the subsidary? Unfortunately, in the currentl release, there is no support for different forms for different users. This won't be seen in the next release either. Some people have tried to so this by installing multple app servers that ea...

Looking to change pivot table orientation
I'm using Excel 2007 and have a pivot table with many values and no row labels. This is making the pivot table very wide - like 15 columns and I'm wondering if there's a way to switch the orientation so that it would be 2 columns and 15 rows instead of 2 rows and 15 columns. Just move the fields around in the field list "eggman2001" <sodani@gmail.com> wrote in message news:4e21a055-eace-433c-b38f-73a93eb2566e@d34g2000vbl.googlegroups.com... > I'm using Excel 2007 and have a pivot table with many values and no > row labels. This is making the ...

Loan Calculator A Must Look!!! #4
Excellent resource on Loan calculation: http://cash-experts.com/LC.asp ...

Calculating no of work days between two dates
Please advise how to calculate the number of work days (excludin weekeends and holidays) between two date -- fluffywhitedo ----------------------------------------------------------------------- fluffywhitedoh's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3528 View this thread: http://www.excelforum.com/showthread.php?threadid=55075 =NETWORKDAYS(start_date,end_date,holidays) holidays is a range of holiday dates. You will need to have the Analysis Toolpak installed, Tools>Addins, and cheek it. -- HTH Bob Phillips (replace somewhere in email address ...

Same proc... same data source... different results
Hi guys, A developer in our office has come to me asking for assistance, and I have no idea what can be causing this. We're running SQL Server 2005 SP3. We have a (when printer) 23 page long stored proc which gathers and formats data for a report. The proc makes use of Temp tables, table variables, FOR XML PATH, Rank(), Partion etc. She runs the proc... and stores the result set to a .txt file. She then runs it again, stores the data to a 2nd txt file. She then uses WinMerge to look at the differences between the two files, and they differ. Out of the 80,000 rows or some...

Pivot Table ... DIV/0 ... Error
Excel 2000 ... I have an inserted calculated Field in my Pivot Table ... Issue is, many of the cells in this Field are returning "DIV/0" error. Above said ... How do I setup Pivot Table to prevent this??? Note: BLANKS would be fine ... Thanks ... Kha Kha.. You probably need to change the formula in the calculated item to account for zeros. Suppose you have a calculated item with the formula "(y-x)/x" to calculate a variance. If any of the "x" data items have a zero this will return Div/0 errors. To get round it, use the formula "if(x=0,0,(y-x)/x)&q...

FRx DAX Table
Hi everyone!! The company that we are handling is using FRX 6.5 (no service packs were installed)and have a problem with its FRx Currency Translator.Everytime we generate report the report doesn't use the historical rates that was defined in the DAX Table. I greatly appreciate your help on this matter. Ivy Tarrobago Application Specialist Infosoft International Solutions Inc. ...

Stupid Pivot Table question
I've spent an hour now pulling my hair out on what I think should have a simple solution... I have one column of dates and times, another of numerical values. I've created a pivot table, grouped by year, month, and day, with the average of the value calculated for each day. I need to get this data out of the pivot table and into regular cells for another program, with one column of dates and a second of values averaged by day. The problem is that the Pivot Table only seems to store the dates as text, with the year and month values only appearing once. I.e., the first row of my PT has...

Linking to tables on another database
I have a live database (DataB) that is used by someone else that I am connecting to. I have no control over the DataB database and all I want to ever do is pull information without modifying any of the data. If I set up linked tables from my database to DataB, how do I ensure that I set up my database correctly so that it does not modify any of the data on DataB? Thanks! On Tue, 06 Nov 2007 19:05:53 -0800, none <rwinter75@yahoo.com> wrote: Options include: * Put DataB on a readonly share. * Use workgroup security to give the user only readonly rights * In your forms, set Allow Addi...

What is the table that saves next invoice number?
What is the table that saves next invoice number? Look into "RM40401" Regards, -- Mohammad R. Daoud MCP, MCBMSP, MCTS, MCBMSS Mob: +962 - 79 -999 65 85 Great Package For Business Solutions daoudm@greatpbs.com http://www.greatpbs.com http://mohdaoud.blogspot.com/ "Malek" <Malek@discussions.microsoft.com> wrote in message news:3EBED9E0-C024-4C8C-A51C-D7D0BBBF7153@microsoft.com... > What is the table that saves next invoice number? > That depends what invoice number you are talking about. If referring to SOP, the invoice number will be stored according to ...

How do I import data from a table into a working payables batch?
I trying to create a table to import credit card transactions from our corporate card into a working payables batch so it can be posted to payables module as a normal batch? Any help on how and were to start would be greatly appreciated. Pete Can you get the credit card data as a CSV or Excel file? You could use Integration Manager to import the file. "Pete Kaufman" <Pete Kaufman@discussions.microsoft.com> wrote in message news:87FF509E-3A65-4C08-81C9-5058442C2344@microsoft.com... >I trying to create a table to import credit card transactions from our > corporate...

Time received on Outlook 2003 different than system time.
I completed DST updates on all of our computers and used the tzmove.exe to update the calendar for Outlook 2003. The problem now is when I receive new email, the time is about 5 hrs behind the real time in the inbox. But when I double click to open the email, the time on the message is correct. I checked all time zone settings, DST settings, and calendar options. Im stuck for ideas......any suggestions?? Thanks Check the time zone setting on the Exchange server. - RAM On Mar 12, 2:52 pm, "RAM" <rmilbr...@gfnet.com> wrote: > Check the time zone setting on the Exchange s...