matrix drill through on total rows

[Anonymous]

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?

[jaideepnema]

Hi @Anonymous ,
Not very clear do you want to drill down basis the columns instead of rows ?

[Anonymous]

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'...

[Anonymous · Accepted solution]

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