LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
TMore
 
Posts: n/a
Default PivotTable Grand Totals By Item

(Im hoping the table format is somewhat preserved in this post, so that the
question is readable...if not, I apologize!)

If I have a table structured like this:

Product Line Jan Feb Mar
Apples Revenue 500 600 600
Apples Profit 50 60 60
Oranges Revenue 400 500 400
Oranges Profit 25 35 25
Pears Revenue 200 200 100
Pears Profit 40 40 20


I can create a Pivot Table like this:


Product Line SumofJan SumofFeb SumofMar
Apples Revenue 500 600 600
Profit 50 60 60
Apples Total 550 660 660
Oranges Revenue 400 500 400
Profit 25 35 25
Oranges Total 425 535 425
Pears Revenue 200 200 100
Profit 40 40 20
Pears Total 240 240 120
Grand Total 1215 1435 1205


But I would also like to have the pivot table include rows near the bottom
for €śGrand Total Revenue€ť and €śGrand Total Profit€ť (rather than giving me the
Grand Total of Revenue + Profit, which isn't meaningful).

Is this possible?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic parameterized PivotTable update? Nick Keller Excel Discussion (Misc queries) 0 February 24th 06 11:02 PM
PivotTable Calculated Item error [email protected] Excel Discussion (Misc queries) 1 September 28th 05 09:32 AM
Need to sum up numerous columns in different worksheet into 1 devil135 New Users to Excel 3 May 26th 05 03:32 PM
Linking Several Worksheets to One Worksheet TangentMemory Excel Discussion (Misc queries) 1 May 10th 05 11:37 PM
PivotTable toolbar, Formulas, Calculated Item Jacob Excel Discussion (Misc queries) 1 March 19th 05 01:15 PM


All times are GMT +1. The time now is 12:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"