Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
)
