Pivot table proportion of a column

[#1]

Hi,

I have a pivot table with three columns: sales, proportion %, and cummulative sales. My issue is when I calculate proportion of sales, I do the following:

sum(Sales)/sum(total(Sales)

The problem is total function evaluates sales over every dimension and I'm interested in the proportion of sales relative to its column total which is based on month. I've attached an example for you to see. If no month is selected, the proportion of sales is incorrect. If a month is selected, the proportion of sales/column sums correctly. My goal is to show the proportion of sales per month.

Hope this explanation's clear. Let me know if you have any questions and thanks in advance for the help.

Matt

[jonathandienst · Accepted solution]

Matt

sum(Sales)/sum(total<Month> Sales)

should so the trick

Hope that helps

Jonathan

[#3]

Worked perfectly.

Thank you very much for your help Jonathan!

Matt