Forum Discussion
matrix drill through on total rows
Hi
I have a matrix table which i am able to drill through to record level details successfully. Any ideas how to set this up so I am also able to drill through on the Total rows also please?
- Anonymous4 years ago
Hi Anonymous ,
You can refer the solution in the following thread to achieve it.
Filtering in Matrix report based on overall subtotal value
1. Create a measure to get the total value by "category"
2. Create a visual level filter: apply the above measure in Filters pane
Best Regards
3 Replies
- jaideepnema
Solution Sage
Hi Anonymous ,
Not very clear do you want to drill down basis the columns instead of rows ?- AnonymousNot applicable
Thanks, I do not want to drill down , i want to drill through. I can already drill through on the rows and columns on the individual months i.e. 'Jan 4.27' but i cannot on the total i.e. on the the '4.62'...
- AnonymousNot applicable
Hi Anonymous ,
You can refer the solution in the following thread to achieve it.
Filtering in Matrix report based on overall subtotal value
1. Create a measure to get the total value by "category"
2. Create a visual level filter: apply the above measure in Filters pane
Best Regards