Forum Discussion
Solved
Filtering across column headers?
Hi there, I have a dataset which provides client status across a different field - sample data below where i've used region and my companies on the database. I want to be able to filter on a reg...
Hi AMARSHALL80
It is actually possible to do this, but I don't really consider it a "clean" way.
- edit the query
- duplicate the table you want to filter based on columns
- select all the columns you want to be able to filter (using shift and or control)
- right-click and select unpivot data
- now you can filter based on the new "attributes" column
Notice how this is not a good suggestion for large data as you have to copy the entire table.
It works though...
To actually implement the filter I would recommend using the chiclet slicer from the custom visuals store
Thank you Anonymous and SushainKoul - really appreciate you coming back.
The unpivot is helpful and the duplicating of table seems to be getting me closer, but i dont it quite does what i am hoping to do (and i used regions just as sample data) - i would like to be able to filter on a Region and Status (e.g. USA Clients) to then show how those Clients (or other status selected) perform across other regions.