Getting Cumulative Percentage from a breakdown of a field
I have items for 3 months and they are under same "month" field but grouped by April, May, June.
Under each month, there are managers and there are employees under each manager.
What I'm trying to do is getting percentage that accumulates from employees to manager then to each month.
Eventually totaling up to 100%.
I can get the percentage breakdown of employees, but it doesn't accumulate accordingly. Also, The table sums all the items for all 3 months and gets the percentage which give me around 30% for each month. I want sum of total items separately so it will give me total of 100% for each month but I can't figure out how.
Here is the expression that I used
and there is the snapshot of part of my pivot table. Thank you for your help!