Custom total in PivotTable

B

Boris Å avc

How do you add a custom total in a PivotTable! For instance:

Field1 Field2 Field3
DATA DATA DATA
DATA DATA DATA
DATA DATA DATA
TOTAL (all DATA under Field3 column)

I've tried it with grand total but it doesn't work. The only way was to
insert new calculated field and grand total, but that gives me two same
data columns at the end.

Thanks for helping,
Boris
 
Top