nasolmeHelper I4 years agoSolvedhide subtotal Hi community ! I would like to keep only the grand total for "Loan" columns. I can use : IF(HASONEVALUE(ASSET[ASSET_NUMBER]),blank(),sumx(SUMMARIZE(DATA,DATA[FILE_NUMBER],"average",average(D...Show MoreSpartaBI4 years agonasolme IF(ISINSCOPE(ASSET[ASSET_NUMBER]),blank(),sumx(SUMMARIZE(DATA,DATA[FILE_NUMBER],"average",average(DATA[ENCOURS.MT_EXPO_BRUT_Engagements])),[average]))
SpartaBI4 years agonasolme IF(ISINSCOPE(ASSET[ASSET_NUMBER]),blank(),sumx(SUMMARIZE(DATA,DATA[FILE_NUMBER],"average",average(DATA[ENCOURS.MT_EXPO_BRUT_Engagements])),[average]))
SpartaBI4 years agonasolme IF(ISINSCOPE(ASSET[ASSET_NUMBER]),blank(),sumx(SUMMARIZE(DATA,DATA[FILE_NUMBER],"average",average(DATA[ENCOURS.MT_EXPO_BRUT_Engagements])),[average]))
SpartaBICommunity Champion4 years agonasolme IF(ISINSCOPE(ASSET[ASSET_NUMBER]),blank(),sumx(SUMMARIZE(DATA,DATA[FILE_NUMBER],"average",average(DATA[ENCOURS.MT_EXPO_BRUT_Engagements])),[average]))
Related contentHide duplicative subtotals in matrixCustomize subtotal in matrixHide an specific subtotal field on the matrixHide visualMatrix subtotal
