Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
CB308
Contributor III
Contributor III

Column % to Total calculation in pivot table

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))

Any suggestions?

product4MthPlanLastYearPlan% TtlPlan%LY
Totals1415435100%225.3%
Travel50020035.3%150%
Soft85022560.1%277.8%
Access65104.6%550%
1 Solution

Accepted Solutions
dwh1104
Creator II
Creator II

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

2 Replies
dwh1104
Creator II
Creator II

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

CB308
Contributor III
Contributor III
Author

THANK YOU!!  Worked perfectly