Forum Discussion

AMARSHALL80's avatar
AMARSHALL80
Frequent Visitor
5 years ago
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...
Need Help
  • SushainKoul's avatar
    SushainKoul
    5 years ago

    Hi AMARSHALL80

    It is actually possible to do this, but I don't really consider it a "clean" way.

    1. edit the query
    2. duplicate the table you want to filter based on columns
    3. select all the columns you want to be able to filter (using shift and or control)
    4. right-click and select unpivot data
    5. 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 

AMARSHALL80's avatar
AMARSHALL80
Frequent Visitor
5 years ago

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.   

SushainKoul's avatar
SushainKoul
Helper III
5 years ago

Hi AMARSHALL80 

Welcome. Didn't you still get the solution u were looking for??

  • AMARSHALL80's avatar
    AMARSHALL80
    Frequent Visitor
    5 years ago

    Hi SushainKoul  - having looked at it again i think it has - thank you.  

    • SushainKoul's avatar
      SushainKoul
      Helper III
      5 years ago

      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.