Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Remove Some subtotals from Matrix

 

Hi I would like to remove some subtotals from a matrix table, like this:

 

I tried with this formula, but something is missing from it:

MTD =
IF(
    ISINSCOPE(CanalGrup[Canal 2]),
    IF(
        ISINSCOPE(CanalGrup[Canal 2])=BLANK(),
        IF(ISINSCOPE('dw_si DimChain'[Chain]), IF(SELECTEDVALUE(UnitateMasura[Tip])="Value",TOTALMTD( SUM('dw_si FactSI'[TotalValue]),'Calendar'[Date]),TOTALMTD( SUM('dw_si FactSI'[Quantity]),'Calendar'[Date])),BLANK()),
        IF(SELECTEDVALUE(UnitateMasura[Tip])="Value",TOTALMTD( SUM('dw_si FactSI'[TotalValue]),'Calendar'[Date]),TOTALMTD( SUM('dw_si FactSI'[Quantity]),'Calendar'[Date]))
    ),
    IF(SELECTEDVALUE(UnitateMasura[Tip])="Value",TOTALMTD( SUM('dw_si FactSI'[TotalValue]),'Calendar'[Date]),TOTALMTD( SUM('dw_si FactSI'[Quantity]),'Calendar'[Date]))
)
 
Thank you!

3 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Anonymous 
    Please try
    IF ( 
    ISBLANK ( SELECTEDVALUE ( CanalGrup[Canal 2] ) ) && HASEONEVALUE ( CanalGrup[Canal 2] ),
    BLANK ( ),
    "The rest of the calculation...
    )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you tamerj1 

    I tried your solution but nothing is happening 😐

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    The problem is that I have to crate another channel named: "Direct Secom", which is a total of "LL Other", "Farmacii Independente" and "LL KA":

    And the chain is from another table. 

    So I have Level 1 Channel/Canal drilled down level 2, which is Chain for all level 1 except "Direct Secom", which has "LL Other", "Farmacii Independente" and "LL KA".