Forum Discussion
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 add up to 600. When i use filters subtotal also exclude the filtered value because of that it doesnt work. Are there a workaround this?
| Sales | |
| Tier 1 | 100 |
| Tier 2 | 150 |
| Tier 3 | 170 |
| Tier 4 | 180 |
| Subtotal | 600 |
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
5 Replies
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
TomMartens Thanks but i am trying to completely hide row where Tier + Tier 4. Not just the sales amount.
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
This worked for me! Thanks!!
TomMartens Yes this worked. Thanks
