Forum Discussion
Drill Through Question
Hi,
I created a report with two pages, on the main page, I have a list of cases
When I click on a case, I am taken to another page, with case details, let's take A11 for example:
My issue comes in when a case has more than 1 subject - A13, has 3 subjects. When I click on A13, "Detailed Case View" tab shows information for that specific subject rather than all 3. My initial solve was to concatenate subject names and complaints, so there is only 1 line for A13 but my solution was declined.
The user wants to keep the main page view as is, and when clicking on A13, "Detailed Case View" tab should show all the subjects in the case. Can someone help me achieve this?
Desired Outcome on Detailed Case View when clicking on A13
Sample PBI:
You need to use a shadow copy of your table and then use a measure to transfer the partial filter from the drillthrough to the shadow table.
2 Replies
You need to use a shadow copy of your table and then use a measure to transfer the partial filter from the drillthrough to the shadow table.
Thank you so much!
