row totals in % of column with 2 dimensions

[PLE]

Dear all, I have a pivot with row totals in % of totals. See attached picture 1.

All numbers are based on a % calculation of Turnover, hence Turnover being at 100%.

Now I would like to see these numbers to be calculated based on 2 different locations so that I can compare this between the locations. So I add the dimension Location to the value table.

See attached picture 2.

What qlik does is recalculate all % numbers based on these 2 columns instead of treating each column as a distinct column. Hence the Turnover now beging displayed as 14% and 86% instead of each column showing its 100% again.

Does anybody know the formula to use to make this correct.

Thanks.

[jbhappysocks · Accepted solution]

Hi

Add total <Location> in your denominator

So something like

 sum(RowCalculation) / sum(Turnover)

->

sum(RowCalculation) / sum( total <Location> Turnover)

[PLE]

many thanks ! it works.