Pivot table % to Grand total

Refer the below pivot table Sum of sales2 is (Show data as % of Col total)
sum of field1 is Calculated field where i want data to come as 19.98% for product A (i.e 14.98%+5%)
(Excel file also attached)

Product Sum of Sales Sum of Sales2 Sum of Field1
A 335 14.98% 335.05
B 398 17.79% 398.05
C 485 21.68% 485.05
D 225 10.06% 225.05
E 356 15.91% 356.05
F 438 19.58% 438.05
Grand Total 2237 100.00% 2237.05

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.