How to adjust formula with new level added

[Anonymous]

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

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

not sure how to deal with this..

thanks

[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?