Forum Discussion
Table Filter based on value from another table in different page
Hi Team,
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% |
| Meal Kits | 25 | 8 | 24.20% |
| Floral | 58 | 9 | 13.40% |
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.
Kndly suggest
17 Replies
- parry2k
Super User
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
- parry2k
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.
