Hello,
I've attached an oversimplified sample workbook for reference - it would be a company and its employees.
I wish to be able to filter on any dimension for a list of employees, but be able to see ALL data related to that employee.
For example,
- Filter on Dept to IT:
- See ID" AAA" including their Acct, Sales departments and jobs
- Create a calculated field for part-time (PT) jobs, and see all data for ID AAA and CCC including their FT jobs
While this sample file only has a couple of dimensions, the actual data set will have many dimensions, calculated fields and filters
The SQL equivalent would be something like: SELECT * FROM SHEET1 WHERE ID IN (SELECT ID FROM SHEET1 WHERE <FILTERS>)
My first thought is some kind of dynamic set, but am open to other suggestions!
Thanks in advance!
Here is another solution which does not use action filters but used LODs and a new parameter for Department. as shown below:
Hope this helps. Updated workbook is attached for reference.
