Discussion Board for collaboration related to QlikView App Development.
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
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
View solution in original post