Solved: Pivot Table % Cal Issue - Qlik Community

subbareddykm · ‎2020-01-13

HI All,

i am wondering how to caluclate the % on column level 100% in Pivot Table.

Its not giving me the column level % but its giving me the oveal %.

Can any one tell me how to achieve the below one

jonathandienst · ‎2020-01-13

Something along the lines of:

Sum(Amount) / Sum(TOTAL <Month> Amount)

This called a partial total and its much like the subtotals in a pivot table

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

jonathandienst · ‎2020-01-13

Something along the lines of:

Sum(Amount) / Sum(TOTAL <Month> Amount)

This called a partial total and its much like the subtotals in a pivot table

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Pivot Table % Cal Issue