Total on Pivot

qlikviewaf — Tue, 10 Jul 2018 15:22:24 GMT

hi , i have this pivot, and i would like to have on both rows the value 203330 . Which is the formula i have to use?

Currenlty the formula is the one below, i tried to use SUM( TOTAL (Formula)) but is not working.

How i can fix this? Thanks

if(vExcludeInstrumentSales,sum(TOTAL{<ItemNumber=,Item_Description_1=,Brand_Description=,ImportType={'JDE'},Year = {"$(=Max(Year)-1)"},Country_Desc={'Italy'},Product_Line_Description={'KNEES','HIPS'}>}ExtendedOriginal),Sum(TOTAL{<ItemNumber=,Item_Description_1=,Brand_Description=,ImportType={'JDE'},Year = {"$(=Max(Year)-1)"},Item_Category={$(vNoInstruments)},Country_Desc={'Italy'},Product_Line_Description={'KNEES','HIPS'}>}ExtendedOriginal))

(

if(vExcludeInstrumentSales,sum({<ImportType={'JDE'},Country_Desc={'Italy'},Product_Line_Description={'KNEES','HIPS'}>}QtySoldADJ),Sum({<ImportType={'JDE'},Item_Category={$(vNoInstruments)},Country_Desc={'Italy'},Product_Line_Description={'KNEES','HIPS'}>}QtySoldADJ))

(if(vExcludeInstrumentSales,sum({<ImportType={'JDE'},Year = {"$(=Max(Year)-1)"},Country_Desc={'Italy'},Product_Line_Description={'KNEES','HIPS'}>}ExtendedOriginal),Sum({<ImportType={'JDE'},Year = {"$(=Max(Year)-1)"},Country_Desc={'Italy'},Product_Line_Description={'KNEES','HIPS'},Item_Category={$(vNoInstruments)}>}ExtendedOriginal)))

(if(vExcludeInstrumentSales,sum({<ImportType={'JDE'},Year = {"$(=Max(Year)-1)"},Country_Desc={'Italy'},Product_Line_Description={'KNEES','HIPS'}>}QtySoldADJ),Sum({<ImportType={'JDE'},Year = {"$(=Max(Year)-1)"},Country_Desc={'Italy'},Product_Line_Description={'KNEES','HIPS'},Item_Category={$(vNoInstruments)}>}QtySoldADJ)))

if(vExcludeInstrumentSales,sum({<ImportType={'JDE'},Year = {"$(=Max(Year)-1)"},Country_Desc={'Italy'},Product_Line_Description={'KNEES','HIPS'}>}QtySoldADJ),Sum({<ImportType={'JDE'},Year = {"$(=Max(Year)-1)"},Item_Category={$(vNoInstruments)},Country_Desc={'Italy'},Product_Line_Description={'KNEES','HIPS'}>}QtySoldADJ))

if(vExcludeInstrumentSales,sum(TOTAL{<ItemNumber=,Item_Description_1=,Brand_Description=,ImportType={'JDE'},Year = {"$(=Max(Year)-1)"},Country_Desc={'Italy'},Product_Line_Description={'KNEES','HIPS'}>}QtySoldADJ),Sum(TOTAL{<ItemNumber=,Item_Description_1=,Brand_Description=,ImportType={'JDE'},Year = {"$(=Max(Year)-1)"},Item_Category={$(vNoInstruments)},Country_Desc={'Italy'},Product_Line_Description={'KNEES','HIPS'}>}QtySoldADJ))

)

Re: Total on Pivot

sunny_talwar — Tue, 10 Jul 2018 15:33:21 GMT

Would you be able to share a sample to look at and test it out?

topic Total on Pivot in QlikView

Total on Pivot

Re: Total on Pivot