Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I used following formula in the pivotal table dimension to find the area sales as of % of the division.
aggr(sum({<FiscalYear={2015},FiscalMonth={"4")>}Sales),Division,Area)
/
aggr(sum({<FiscalYear={2015},FiscalSeq={"4"}>} Sales), Division)
I am not getting the result for some reason, out of three divisions, I'm only seeing values for one area, and they are null for all other area. I wonder what's wrong with my formula. I tried top and bottom part of the division individually, and they all worked perfect fine. but when I tried to do the division, then I am not getting the value in every area.
did I do something wrong here? what's the best approach of creating % of division total ( not the grand total, as there are number of division) in pivot table DIMENSION, not expression (for client request, I cannot do it as an expression....)
thanks
try this :
aggr(sum({<FiscalYear={2015},FiscalMonth={"4")>}Sales),Division,Area)
/
aggr(sum({<FiscalYear={2015},FiscalSeq={"4"}>} total <Area> Sales),Division,Area)
Try this expression
aggr(sum({<FiscalYear={2015},FiscalMonth={"4")>}Sales),Division,Area)
/
aggr(sum(TOTAL {<FiscalYear={2015},FiscalSeq={"4"}>} Sales), Division)
Or
( Expression1 / Expression2 ) * 100
Regards
Anand
try this :
aggr(sum({<FiscalYear={2015},FiscalMonth={"4")>}Sales),Division,Area)
/
aggr(sum({<FiscalYear={2015},FiscalSeq={"4"}>} total <Area> Sales),Division,Area)