Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
(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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Dynamic parameterized PivotTable update? | Excel Discussion (Misc queries) | |||
PivotTable Calculated Item error | Excel Discussion (Misc queries) | |||
Need to sum up numerous columns in different worksheet into 1 | New Users to Excel | |||
Linking Several Worksheets to One Worksheet | Excel Discussion (Misc queries) | |||
PivotTable toolbar, Formulas, Calculated Item | Excel Discussion (Misc queries) |