Getting Cumulative Percentage from a breakdown of a field

[rofa84]

Hello experts, 

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 

SUM([Item1])/Sum(total<Employees, Manager>Item1)

and there is the snapshot of part of my pivot table. Thank you for your help!

[Vegar]

What happens if you add month as well as an exception in the totaling? Like this:

SUM([Item1])/Sum(total<Employees, Manager, Month>Item1)

[rofa84]

I already have tried that one too but it still gives me the same result

[Channa]

SUM([Item1])/Sum(total< Manager>,<Month>Item1)

[Vegar]

It could be something with your data that you missed mentioning.

Could you try to create a (simplified) sample app for us? It would make
it easier to understand your issue and l to help.

—Vegar

[rofa84]

This one give me and error. I don't think there should be a comma