Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikuser222
Creator
Creator

Help with Pivot table?

Hi Everyone,

I have a pivot table and i m not getting expected results when i  use Total function. Can anyone please help me to understand where i went wrong?

Please find attached document which explains my problem with example.

1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

use Sum(Net)/Sum(Total <Group> Net) for your % column.

View solution in original post

2 Replies
neelamsaroha157
Specialist II
Specialist II

use Sum(Net)/Sum(Total <Group> Net) for your % column.

ali_hijazi
Partner - Master II
Partner - Master II

the sum total net should take into consideration the Group dimension

so your expression should be sum(Net)/Sum(Total<Group>Net)community.PNG

I can walk on water when it freezes