Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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