cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Reh Frequent Visitor
Frequent Visitor

Group multiple columns into single filter

Hi, Please see below. I have 3 columns with name of companies that can repeat row to row. How do I create a table with column 1 and column 2 info that can be filtered by by name of the companies from column 3, 4 and 5? I'd appreciate your help!  

 

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Group multiple columns into single filter

Hi @Reh 

 

You may click the project # and project cost columns and then use 'Unpivot other columns' in query editor.Then filter out the blank values.Use the value column as slicer to get the visual.

1.png

1.png

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: Group multiple columns into single filter

Hi @Reh 

 

You may click the project # and project cost columns and then use 'Unpivot other columns' in query editor.Then filter out the blank values.Use the value column as slicer to get the visual.

1.png

1.png

1.png

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.