Forum Discussion
Lookup Value Based on 2 Citeria and Multiple Tables
I have a need to narrow down and select information based on criteria selections. Step 1 lookup the discipline (civil) and return the abbreviation code (C), not shown. Step 2 select the group tha...
Create a flat table with only these columns (repeat the information in a column if there are multiple items in the subsequent columns):
Discipline
Discipline Code
Abbreviation
Abbreviation code
Group
Group Code
Once that is in place you can simply use a handful of Slicers to filter this table.
Discipline
Discipline Code
Abbreviation
Abbreviation code
Group
Group Code
Once that is in place you can simply use a handful of Slicers to filter this table.
Thank you for the response. The slicers are a great tool. However, how do i apply them to 1000 rows that will be different for each row?
- Not sure what you mean?