Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
jfung148
Creator
Creator

How to adjust formula with new level added

hi

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..

expanded1.JPG

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

expanded2.JPG

not sure how to deal with this..

thanks

1 Reply
sunny_talwar

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?