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.

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