Pivot Table Calculated Field

[Nine Zero]

Hello,

I have a pivot table with 3 columns of data and a grand total column as well.

I would like to add a calculated field to the right of the grand total column that is doing the calculation

11% * grandtotal

my issue is how do i access the already calculated field of the grand total>?

 

[jarjarbingie]

Hello,

I have a pivot table with 3 columns of data and a grand total column as well.

I would like to add a calculated field to the right of the grand total column that is doing the calculation

11% * grandtotal

my issue is how do i access the already calculated field of the grand total>?

you cannot use the Grand Total in a calculated field, you have 2 options:

(1) create the calculation outside the pivot
(2) mimic the Grand Total calculation in a calculated field, say, measure1+measure2+measure3, then use that calculated field to multiply by 11%