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

Anonymous — Thu, 23 Jun 2016 19:51:42 GMT

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?

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

aakash_fractal — Thu, 26 Sep 2019 07:39:18 GMT

Anyone with the solution?

Thanks.

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

Mak3 — Mon, 16 Aug 2021 11:40:48 GMT

HI All,

If Solved, please share the solutions.

Thanks in Advance

topic Pivot Table +Dimensionality () + Sum(Total <> Sales) in QlikView

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

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

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