Discussion Board for collaboration related to QlikView App Development.
I have a calculated column (which is the total of column(1)+column(3)+column(5)+column(7) labeled "4MthPlan"
In a pivot table, I would like to show the % to total of this column "4MthPlan" to the total of "4MthPlan". See example below of expected data.
I have tried the following and none work.
sum("4MthPlan") / sum (Total ("4MthPlan"))
sum(column(8) / sum (Total (column(8))
I think one way you can accomplish what you are trying to do is by using variables. See the attached QVW.
View solution in original post
THANK YOU!! Worked perfectly