cancel
Showing results for 
Search instead for 
Did you mean: 

How to create a filter that lets select from two different columns from a Table?

Astroraf
11 - Data Pipeline
11 - Data Pipeline

Let's say from a table called customers; I want to give a person the option to choose column a or column b from a drop-down menu from the customer's table. Is there a way to achieve this in Sisense? Maybe via a BloX widget?

 

@DRay @Liliia_DevX 

1 ACCEPTED SOLUTION

Liliia_DevX
Sisense Team Member
Sisense Team Member

@Astroraf Thanks for the clarification. Please examine the solution described in this post: 

https://community.sisense.com/t5/knowledge-base/switch-multiple-rows-in-pivot-as-viewer/ta-p/8871

It should help to achieve your goal 🙂 

Best Regards,
Lily

View solution in original post

4 REPLIES 4

Liliia_DevX
Sisense Team Member
Sisense Team Member

@Astroraf Hi 🙂

Could you please clarify how you expect it to behave after the user selects a column from the drop-down list? Additional clarification or your end goal will help us provide you with the correct suggestions.

 

Best Regards,
Lily

Astroraf
11 - Data Pipeline
11 - Data Pipeline

Hi @Liliia_DevX 

In my pivot table, the Index column or first column would switch between column a or column b. 

Liliia_DevX
Sisense Team Member
Sisense Team Member

@Astroraf Thanks for the clarification. Please examine the solution described in this post: 

https://community.sisense.com/t5/knowledge-base/switch-multiple-rows-in-pivot-as-viewer/ta-p/8871

It should help to achieve your goal 🙂 

Best Regards,
Lily

DRay
Community Team Leader
Community Team Leader

Hello @Astroraf ,

I’m following up to see if the solution offered by @Liliia_DevX worked for you.

If so, please click the 'Accept as Solution' button on their post. That way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.

David Raynor (DRay)

Type a product name