Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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