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

Question

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 Kislitsyna · Accepted Answer

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/8871It should help to achieve your goal 🙂

DRay · Answer

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.

Rafael Ferreira · Answer

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

Liliia Kislitsyna · Answer

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.