| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Grand Total in Pivot Table Row Area
I am creating a Pivot Table over sum of Balance Due in Data area of a
pivot table. In the row area of the pivot table I have a Credit Limit Field and the user would like the total overall balance due in the row area next to this field. Is it possible to get the total of Balance due in the row area. Thought I could use Calculated Field but that can only be used to add to the Data Area and calculated item requires the field already to be in the row area. Anyone have any suggestions? Is it possible to get the Grand Total of the Data added to the Row Area? Stuart |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Grand Total in Pivot Table Row Area
Take a look at these two sites. These are two great resources for Pivot
Tables!! http://peltiertech.com/Excel/Pivots/pivottables.htm http://www.contextures.com/xlPivot02.html Regards, Ryan-- -- RyGuy "stuart62" wrote: I am creating a Pivot Table over sum of Balance Due in Data area of a pivot table. In the row area of the pivot table I have a Credit Limit Field and the user would like the total overall balance due in the row area next to this field. Is it possible to get the total of Balance due in the row area. Thought I could use Calculated Field but that can only be used to add to the Data Area and calculated item requires the field already to be in the row area. Anyone have any suggestions? Is it possible to get the Grand Total of the Data added to the Row Area? Stuart |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Grand Total | Excel Discussion (Misc queries) | |||
| Pivot Table (Grand Total) | Excel Discussion (Misc queries) | |||
| Pivot Table Grand Total | Excel Discussion (Misc queries) | |||
| PIVOT TABLE - GRAND TOTAL COLUMN | New Users to Excel | |||
| Grand total in Pivot-Table | Excel Worksheet Functions | |||
Linear Mode
