I've got a two page report, an overview page and a details page.
The data is proprietary so let me use an example with a similar data model. Let's say I'm modeling items in a grocery chain. I've got columns for "store," "aisle," and "type."
My overview page has a stacked bar chart showing a count of each "type" of item for each "store." (So: "store" is on the y axis, "count" is on the x axis, and the stacked bars breakdown the count by "type.") I also have a slicer that lets users select which type of products they would like to see.
On the details page, I have a similar stacked bar chart, except instead of having "store" on the y axis, I have "aisle." You can see what I'm going for by now, I think. The overview shows the breakdown of item types by store, and then you drillthrough on a store to see the same sort of breakdown by ailse.
Here's the rub, though: when I drill through from the overview page, it's over specific. The section of the bar I select will affect the values seen on the details page, which I don't want. In other words, it's drilling through on both "store" and "type" and I only want it to drill through on "store" even though having "type" in the details page chart is also important. I have thought about creating a duplicate column - "type2" - but I also use that "type" slicer on the details page and it's synced with the overview page.
After the fact, I can manually delete the "type" filter in the right pane under drillthrough, both in desktop and on the web report, so there must be a way to trigger that programmatically. How can I do that?
