I have a straight table that contains a BOM of technical installations. I want to be able to filter the Configuration Files that contain the desired items, not the actual rows. Is that possible?
Config File Name
Item Name
FileA
Panel
FileA
Detector
FileA
Software
FileB
Detector
FileB
Software
FileB
Hardware
FileB
Line Element
FileC
Software
FileC
Panel
...
My bar chart's dimension is [Item Name] and the measure is count([Item Name])
Let's assume I click on Panel in the bar chart, I want the filter to be applied in [Config File Name] for FileA and FileC. Is there a way to do that?
I think your answer lies in the use of Alternate states as your setting a filter on item in your default state and wanting to use the answer i.e the 2 config files in your other state but including all items relating to those config files.
