Thread: Pivot: Percentage of Subtotal and Total

Hello All,

I have created an old fashioned pivot table. I would like to have it show percentage of subtotal and show percentage of Grand Total, to 3 decimal places. See REPORT tab. In column D of attachment, I have entered in text what I would like to see in this column for INCOME, EXPENSE, AND SPENDING pivot table. But I'm stuck. Can any one help

Thanks

I've adjusted your SOURCE. See the summary

HTML Code:

=B2/SUMIF(A$2:A$9,"="&A2,B$2:B$9)