Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
fransnylin
Contributor II
Contributor II

Calculation order of Pivot Tables in QlikSense

Hi all,

I have a Pivot Table in QlikSense, and users love it. Now we want to add two new fields and I need to control the order in which they are calculated.

A) I have a percentage that needs to be calculated on each line (not aggregated bottom up)

B) I have a total cost that needs to be aggregated bottom up, not calculated line by line. Its calculated as avg(price) * quantity and it needs to come bottom up.

I have googled and searched but not found the right answer. Any ideas?

Thanks

Frans

Labels (1)
2 Replies
Channa
Specialist III
Specialist III

put some sample how it is and what you looking for

Channa
fransnylin
Contributor II
Contributor II
Author

Hi,

See pictures below.

a) I want to make sure that percentages are calculated on a line by line basis

b) Prices should instead be summed up bottom up (as quantity and average price will be super wrong)

Percentage to be calculated line by linePercentage to be calculated line by linePrice to be summed bottom upPrice to be summed bottom up

 

 

 

 

Any ideas?

Thanks

Frans