Custom calculated subtotals on a pivots table

[SinKoh]

I have an issue with a pivot table I am building for a client. The percentages of each row group are subtotaling causing the number to be wrong. In the image below you will see that the dollars are all summed that is fine. But the percentages are summing as well causing them to displaying really high incorrect values. Is there a way for me to get a the percentages of the subtotaled numbers from the summed dollar amount? Example: ( $7,961,492 - $5,259,319 ) / $7,961,492 is 33.9%. So I would want to display 33.9% of the subtotal row.

https://imgur.com/a/OhPoP


Any help would be greatly appreciated.

Thanks,
Matt

 

[Worf]

Hello Matt

Seems that you need a calculated field or item:

http://www.contextures.com/calculatedfieldcalculateditem.html