Total on Pivot

[qlikviewaf]

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))

)

[sunny_talwar]

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