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.
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
Retrieving data ...