Forum Discussion
Hiding selective rows in matrix
Hi Colleagues Colud you advise what measure should I apply to get the effect : hiding selective rows in matrix without affecting subtotals I am preparing the report and I want to show only 1 selet...
if you are using a simple table you can use isfiltered function
if you are using a matrix visual you can use isinscope function
these 2 functions can be used to control the calculation base on the where you are in a visual ( row level , total level , subtotal level)
hope this helps
Many thanks Daniel29195 but i am still don`t know how it should work. When I connect this function with SUM(...) this summirize only selected value but I wonder if there is possible to sum up all values as subtotal and total but show only one category