Forum Discussion
Omit filter from drill through
Hi Anonymous , thank you for your reply.
I am trying to find a way that gives the best user experience and would prefer to avoid asking the user to filter the summary page and then apply the same filters (except product) to the drill through page.
In the end I found another solution:
I referenced the fact table and connected it to all dimesions except the product table, I then used the referenced table in my drill through page which is not filtered by the product dimension. The downside of this approach is that I can't drill through on the measure and instead need to drill through on my dimensions, but I think it gives me the outcome that is best for user experience.
Hi johnbasha33 ,thanks for the quick reply, I'll add further.
Hi JimJim ,
Regarding your question, perhaps you can turn off the 'Keep all filters' option and then set the filter in the drilldown field on the drilldown page.
Best Regards,
Wenbin Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous , thank you for your reply.
I am trying to find a way that gives the best user experience and would prefer to avoid asking the user to filter the summary page and then apply the same filters (except product) to the drill through page.
In the end I found another solution:
I referenced the fact table and connected it to all dimesions except the product table, I then used the referenced table in my drill through page which is not filtered by the product dimension. The downside of this approach is that I can't drill through on the measure and instead need to drill through on my dimensions, but I think it gives me the outcome that is best for user experience.