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

Question & Answer
, ,
1

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?

2

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.

3

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

1 Like
5

image

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

6

Hello @HKPMatt and @ErikG !

@HKPMatt are you still running into this problem or were you able to find find a solution? Or was @ErikG 's response helpful in finding a solution?

If so could you post your workaround to help the community or mark one of the comments above as the solution?

7

Hello @HKPMatt and @ErikG !

It has been some time since we have heard from you but we would still like to help you find a solution.

If there is not activity on this thread in 4 days this topic will be archived.