How to create a percentage calculated field that is level aware?

For example, There are column A and column B.
I want to calculate a calculated field of % that is (column A/column B) and show in a pivot table.
The problem is the calculated field will sum up all the percentage of every breakdown level under its current level in the pivot table.
How do I solve this problem?

For more details, the calculated field can be break down by a hierarchy C, D, E, etc.
I want to show the % of columnA/columnB whenever I expand the level C ,D and even E.

Welcome @HKPMatt
couldnt you just change the aggregation to avg?

1 Like


since there are offsetting at lower hierarchy, averaging the percentage will not work well here.