Like Excel I want percentage by column total.. Not by grand total. I've 3 columns in pivot and in row i've dates

[ezazhaider99]

Hi, One query. Like in Excel pivot we get percentage by column total. How can we get same in Qlik. Data attached... let say for East Region for date 01/01/2020 it is 6 and column total is 23 then  percentage by column total as 6/23 which is 26.08. But when I use below formula in qlik sense it actually doing 6/84 (Grand total). Plz help

sum(Sales)/ sum(TOTAL Sales)

[robert99]

Hi. The Pivot table works this way. I'm almost certain there isn't one setting to change it so every column is treated as being a 100% column. 

If I was asked for this and the column number was small (3 or 4 plus a total) I would use a straight table and have 4 or 5 different measures. But its likely not what you want

Hopefully someone can help 

[robert99]

Hi @ezazhaider99 

Try this

sum(Sales)/ sum(TOTAL <Region> Sales)

This restricts the total to each region. Rather than all regions

Pivot table percentage of total column - Qlik Community - 203033

[ezazhaider99]

Thanks, A very quick response...  Its working with your formula