Forum Discussion
matrix drill through on total rows
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
Solution SageHi Anonymous ,
Not very clear do you want to drill down basis the columns instead of rows ?
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'...
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