cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
srlabhe123 Member
Member

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 DepartmentIn StockOut Stock% OoS
Grocery - Dairy100.00%
Grocery - Floral100.00%
Meal Kits25824.20%
Floral58913.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 17
Super User
Super User

Re: Table Filter based on value from another table in different page

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




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






srlabhe123 Member
Member

Re: Table Filter based on value from another table in different page

can you please elaborate more how to use drill down to achive what I want?

Super User
Super User

Re: Table Filter based on value from another table in different 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.

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






srlabhe123 Member
Member

Re: Table Filter based on value from another table in different page

Step 1 done but when I right click on profit dept in page 1 it doesn't show me any option of drill through to page 2...

Super User
Super User

Re: Table Filter based on value from another table in different page

not sure why, just make sure it is same column in drillthrough.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






srlabhe123 Member
Member

Re: Table Filter based on value from another table in different page

Step 1 :- Added Profit Dept as drill through filter in page 2 as below

step 1.JPGAdded as Drill Throughstep2.JPGNo Page 2 as in list after right click

Super User
Super User

Re: Table Filter based on value from another table in different page

you have to right click on the profit department in a visual not in columns under table, sorry i was not clear.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut! Connect with me on Linkedin






srlabhe123 Member
Member

Re: Table Filter based on value from another table in different page

Its doesnt give me any menu if I right click on visual as well.... 

srlabhe123 Member
Member

Re: Table Filter based on value from another table in different page

I got it .... but its not filtering table in page 2....