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

[Astroraf]

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 

[Liliia_DevX]

@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.

[Astroraf]

Hi @Liliia_DevX 

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

[Liliia_DevX · Accepted solution]

@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 🙂 

[DRay]

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.