When I click on a row within a straight table (as below) I get the row dimension added to my 'Current Selections'. This is great 99% of the time. However, I have a need to provide filtered results based off both the row dimension AND the column dimension.
Example of my need: If I click on 'Numeric Value 1' in the table below my 'Current Selections' box would update with 'Country A'. I would like to have 'Current Selections' update with BOTH 'Country A' and 'Sales Pipeline Status A', so that my adjoining tables have both filters applied to them. Note: 'Sales Pipeline Status A' is a valid field in my database table, not just the 'Label' name for my column header.
Example Table (note: 'Sales Pipeline Status A' and 'Sales Pipeline Status B' are database fields available in my internal QV tables:
| Country | Sales Pipeline Status A | Sales Pipeline Status B |
| Country A | Numeric Value 1 | Numeric Value 2 |
| Country B | Numeric Value 3 | Numeric Value 4 |
| Country C .... | Numeric Value 5 | Numeric Value 6 |
Can somebody explain how I can do this please, if this is indeed possible?
Thank you in advance.
Steve
