PIVOT TABLE Grand Total ... pls help !!!!
Hi,
in a pivot table I need to customize grand total calculation. Is it possible programatically in VBA? What I need is to calculate MARGE:
Revenue BusCat1 10 12 34 54 43 21
OEF 10 13 35 10 01 02
SUBTOTAL 20 25 69 64 44 23
Cost BusCat1 12 12 32 22 23 32
Constract 02 03 10 13 14 10
OEF 15 12 20 10 10 02
SUBTOTAL 29 27 64 45 47 44
Marge -9 -2 05 19 -2 -21
Grand Total is possible, but only as a sum, not minus.
Thanks for help, im really hopeless.
|