I have a pivot table with 3 dimensions, and 2 expressions. I need to show total sales by company when Dimensionality()=1, if Dimensionality ()=2 then Sum total sales by SubBrand and if Dimensionality ()=3 then Sum Total sales by store.
I have this expressions:
IF(Dimensionality()=1,
Sum({$<Discount=,DiscountDescription=,Anio={'$(vMaxAño)'},FlagCatNoExc={1},FlagProdNoExc={1}>} Total TotalSales),
IF(Dimensionality()=2,
Sum({$<Discount=,DiscountDescription=,Anio={'$(vMaxAño)'},FlagCatNoExc={1},FlagProdNoExc={1}>} TOTAL <SubBrand,Store> TotalSale),
Sum({$<Discount=,DiscountDescription=,Anio={'$(vMaxAño)'},FlagCatNoExc={1},FlagProdNoExc={1}>} TOTAL <Store> TotalSale)
)
)
It seems to be working only when I expand all the second dimension, if I only expand the secon dimension from one category it doesnt work. I need the value doesnt change if I expand all the second dimension or only one category
