Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?