cancel
Showing results for 
Search instead for 
Did you mean: 

Using a filter to display data in a table

Former Member
0 Kudos

Hi guys,

First post.

I want to use a filter component with 3 filters to drill down into a Table component.

I have approx 500 rows of data, with 5 fields.

Country |  City | Sector | Company | Rank.

The filter labels will be Country | City | Sector

The table should just show the Company | Rank dependent on user selection.

I can't seem to work out how to do this, or which table component to use. The best I have managed is that one row of data is shown in the table but for some of the filtered results there should be lots of results.

Help would be greatly appreciated.

I may be laying out the destination part incorrectly.

Cheers

J

Accepted Solutions (1)

Accepted Solutions (1)

former_member182541
Active Contributor
0 Kudos

Hi James,

Take the filter mapping logic from the samples of filters i hope you might be missing by incorrect binding of cells, else as a workaround you can use three combo boxes to drill down one by one level. Take a look at the below link for  more details.

Former Member
0 Kudos

Thank you.

Which is the most suitable table component to use in this scenario?

Thanks

former_member182541
Active Contributor
0 Kudos

Answers (0)