Forum Discussion
Disable matrix summarized total
Hi All,
May i know is it possible to disable the auto summarized total in a matrix visual ?
I know that when the rows are collapsed, matrix will automatically apply function Sum to the figures. However, in my report layout, the total up values are meaningless.
So, is it possible to delete the total when rows are collapse ? (delete as in to show nothing in the figure column)
To change from:
change to:
Thanks
Regards,
teng1 , You can disable subtotal and you use the per row option to disable particular subtotal
You can also control it using, isinscope
Switch(True(),
isinscope(Table[Lowset level]), [Meausre],
isinscope(Table[level 1]), [Measure 2],
isinscope(Table[level 2]), blank())
2 Replies
teng1 , You can disable subtotal and you use the per row option to disable particular subtotal
You can also control it using, isinscope
Switch(True(),
isinscope(Table[Lowset level]), [Meausre],
isinscope(Table[level 1]), [Measure 2],
isinscope(Table[level 2]), blank())
Hi amitchandak,
Thanks for showing the direction.
Here is what works for me.
Previously i made a mistake on the lowest level measure.
Regards.
