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

Create a total field for a pivot table/pivotchart
 

Never mind... I figured it out using VBA engineering... and works really well.
..
if anyone comes across with the same issue and wants the code to solve it
just post here and I'll help you out or hit me at djrobilotto yahoo com



rock3775 wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200608/1