0 Replies Latest reply: Jun 23, 2016 3:51 PM by Daniel Sanchez Mendoza RSS

    Pivot Table +Dimensionality () + Sum(Total <> Sales)

    Daniel Sanchez Mendoza

      Hi everyone,

       

      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

       

      Someone can help me?