The filter you are talking about only works across particular sheet.
Hi Deepak, thanks for the response.
Any ideas on how I could work around this issue? As I stated in the original post, a normal filter using the product dimension would work across multiple sheets - but it then wrecks the table calculations I am using in my worksheets. Any ideas on a different approach to get the desired outcome?
You could try dropping the table calc onto the other sheets as either a tooltip or detail level, once the pill is on the sheet then filters generally start to work.
1 of 1 people found this helpful
I found a solution! For anyone who comes across this and has a similar problem, here it is: Creating a Global LOOKUP(MIN(...),0) Filter with a Parameter for "Jedi" Filter and Table Calc Trick
By replacing the lookup filter on the dashboard with a parameter control that called on the lookup filter, I was able to bypass the inability to "apply to worksheets" that you get with a lookup filter (since the lookup filter uses a table calculation)
Good , this would Certainly help many users.