How to adjust formula with new level added

Anonymous — Tue, 09 Jan 2018 23:17:06 GMT

currently I have a pivot table that has 2 levels, where I have formulas to calculate percent to total and avg costs,etc on 2 levels

the levels are fabric type and body class

the current formula is like this (percent to total)

=Sum({<[style],[stylecol]>} sales) / Sum(TOTAL <[2bfasefg]>{<[style],[stylecol]>} sales)

or (average retail)

Sum(Aggr(Sum({<[style],[stylecol]>} sales) * Aggr(([2retail]), [style],[stylecol]),[style], [stylecol]))/Sum(Aggr(Sum({<[style],[stylecol]>} sales),[style],[stylecol]))

the thing is.. when it is 2 levels on the pivot table it calculates fine and shows all the calculations at all the levels..

But when I add the 3rd level(customer).. it doesn't calculate all the levels..

only when u select one specific customer then it will calculate.

not sure how to deal with this..

thanks

Re: How to adjust formula with new level added

sunny_talwar — Wed, 10 Jan 2018 01:02:31 GMT

Would you be able to share a sample file to see what you have and provide the output you expect to see from the sample?

topic How to adjust formula with new level added in QlikView

How to adjust formula with new level added

Re: How to adjust formula with new level added