Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
subbareddykm
Creator II
Creator II

Pivot Table % Cal Issue

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

Labels (1)
1 Solution

Accepted Solutions
jonathandienst
Partner
Partner

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

View solution in original post

1 Reply
jonathandienst
Partner
Partner

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

View solution in original post