pivotguy
11-26-2015, 09:25 PM
Is there a way to add subtotal & subtotal % in pivot table ? The subtotal % will show "% of Row Total".
But Column should not be visible in the spreadsheet. The % will show below Subtotal value as listed below.
See the attached excel spreadsheet for more information.
BRIAN LAVY Total 99.0
BRIAN LAVY % 52.6%
But Column should not be visible in the spreadsheet. The % will show below Subtotal value as listed below.
See the attached excel spreadsheet for more information.
BRIAN LAVY Total 99.0
BRIAN LAVY % 52.6%