Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP
MVP

Re: Pivot Table % Cal Issue

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
Highlighted
MVP
MVP

Re: Pivot Table % Cal Issue

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