Forum Discussion
Helper IIChanging Drill Down
Helper III only have options to lock certain fields, not all of them. The 'column' field itself is a field that doesn't have the lock sign.
I want the drill through report to show all data not just the one you drill down on. i.e if I drill down on a figure in the 'actual' column, I want the drill through to show actual and forecast, not just actual.
Responsive ResidentYeah, I don't know if that will work with the matrix visual, it's going to inherit filter context from both column and row when you drill through.
In order to drill through without filtering the 'column' values you'd need to have a common field value that you drill through on instead. I've gotten around that by creating a calculated column with a single value e.g "View All" and using that to drill through on, but you'd need to use that in another visual outside of the matrix table. I've used a tree map with single value before as it looks somewhat like a button.
the other option could be to rebuild your drill through page using measures that are specifically ignore certain drill through filters.