| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create a total field for a pivot table/pivotchart
is there a way to mimic or create a grand total (using calculated items or
vba) of the row fields selected... similar ot the grand total so, that the data can be displayed on a graph accurately? RowField DataField A 1 B 2 C(not selected) 1 D(notselected) 2 E 1 ------------------------------ Grand total 4 I want the 4 to appear on the graph but, by using grand total that is not possible. Hoping there is a way to create my own grand total. I figured out how to get a grand total of all items A - E (that's easy) but I only want grand total of items selected. Thanks, Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i create multiple pivot tables with one field automatically | Excel Discussion (Misc queries) | |||
| Calculated field in Pivot Tables | Excel Discussion (Misc queries) | |||
| Percent of total in Pivot tables | Excel Worksheet Functions | |||
| caluclated field in pivot table? | Excel Worksheet Functions | |||
| How to create a calculated field formula based on Pivot Table resu | Excel Discussion (Misc queries) | |||
Threaded Mode
