Hello,
Currently I have a straight table with 3 dimensions that I want freezed paned. Lets assume these dimensions are
Deal, Name, Date
Now I have constants as expressions to add on. i.e (Banker,Underwriter,Risk...etc)
The straight table now looks like this :
| Header 1 | Header 2 | Header 3 | Header 4 | Header 5 | Header 6 |
|---|
| Deal | Name | Date | Banker | Underwriter | Risk |
| Deal | Name | Date | Banker | Underwriter | Risk |
Unfortunately when I click into a banker,underwriter.risk or etc... it will filter by the dimensions returning only one row item (the associated deal,name,date with that banker so the current selection in the current selection box is the value of that 1 deal,name,date). Ideally I'd like to see all rows related to the items I click that is an expression. So if I select the banker from the straight table I would like to see all deals associated with that banker. Is there a way in which I can click an expression and get all rows that contain that value using a straight table? It is ideal to have the ability to freeze pain.
