Percentage in a pivot table

[Anonymous]

Hello,

I have a pivot table with 2 columns: Item and Amount. I'd need to know if there is the possibility to add a new column %, with the formula indicated in the image. Exemple: Revenue product A/ Total Revenue, Cost product A/Revenue product A, ect.

[sunny_talwar]

Try this

Aggr(Sum(Amount)/Sum(TOTAL <[Item Category]> Amount), [Item Category], Item)

Where Item Category is a field which will have Revenue and Cost as values