Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
put some sample how it is and what you looking for
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)
Any ideas?
Thanks
Frans