I have a scenario where table1 has columns like Dept, In STock Rev, Out Stock Rev
|Profit Department||In Stock||Out Stock||% OoS|
|Grocery - Dairy||1||0||0.00%|
|Grocery - Floral||1||0||0.00%|
Now hen I click on Grocery -Dairy (any value from column Profit Department)I want another Table 2 should be filtered for Grocery-Dairy values only.Please note the table 2 is on another page in same report.
There are few options:
- use drilldown functionality
- or use report level filters.
Currently selecting a row in a table on one page will not filter data on another page
on your 2nd page, in drillthroug Filters , add field "Profit Department"
on you page1, right click on "Proift Department" and it will show "Drillthrough" option in menu with your 2nd page listed in it, click that and you 2nd page will be filtered based on "Profit Department" you are drilling thru.