Pivot table proportion of a column

Mon, 12 Sep 2011 17:32:37 GMT

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

Pivot table proportion of a column

jonathandienst — Mon, 12 Sep 2011 18:10:31 GMT

Matt

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

should so the trick

Hope that helps

Jonathan

Pivot table proportion of a column

Tue, 13 Sep 2011 09:18:29 GMT

Worked perfectly.

Thank you very much for your help Jonathan!

Matt

topic Pivot table proportion of a column in QlikView

Pivot table proportion of a column

Pivot table proportion of a column

Pivot table proportion of a column