Forum Discussion

dokat's avatar
dokat
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Hide rows in matrix table without affecting subtotal

Hi,   Is it possible to hide rows in matrix table without affecting subtotals and impacting other visuatizations?   In below table i dont want to show row totals for Tier 4 but subtotal to still ...
Need Help
  • TomMartens's avatar
    TomMartens
    4 years ago

    Hey dokat ,

     

    basically, you can't hide something, Tier 4 is shown in my sample because of this property

    If you deactivate the property Tier 4 will be automatically "excluded" from the row headers.

    Regards,

    Tom

TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
4 years ago

Hey dokat ,

 

maybe this measure provides what you are looking for:

Sales w/o Tier4 = 
IF( SELECTEDVALUE( 'Sales'[Tier] ) = "Tier 4"
    , BLANK()
    , SUM( 'Sales'[Sales] )
)

It seems that the below table visual provides what you are looking for:

Hopefully, this provides what you are looking for.

 

Regards,

Tom

dokat's avatar
dokat
Icon for Post Prodigy rankPost Prodigy
4 years ago

TomMartens Thanks but i am trying to completely hide row where Tier + Tier 4. Not just the sales amount.

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    4 years ago

    Hey dokat ,

     

    basically, you can't hide something, Tier 4 is shown in my sample because of this property

    If you deactivate the property Tier 4 will be automatically "excluded" from the row headers.

    Regards,

    Tom