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
Hi AMARSHALL80
Welcome. Didn't you still get the solution u were looking for??
Hi SushainKoul - having looked at it again i think it has - thank you.
Hi AMARSHALL80 .Your Welcome. If u still don't get it or u r facing any problems in this or near future u can ask me.