How to make dynamic calculation in a table based on drop down selection

[HHXIAO]

Dear QuickSight Experts,

I want to create a dashboard with drop down menu for (A, B, C, D) options.

If I choose A, the table should show columns: B vs A (in %), C vs A (in %), D vs A (in %).

If I choose B, the table should show columns: A vs B (in %), C vs B (in %), D vs B (in %)

If I choose C, the table should show columns: A vs C (in %), B vs C (in %), D vs C (in %)

The same if I choose D…

And the calculation should change accordingly.

With which function can I achieve this?

Thanks a lot for your help!

[Giridhar.Prabhu]

Hi @HHXIAO

Welcome to the QuickSight Community!

You can achieve this using calculated fields. I am not sure about how to display the titles dynamically though.

a. Create a static value parameter as follows

b. Add that as a Control with the following settings so user can only select one value

c. Create a calculated field that holds the Base value based on your selection in the parameter

d. Create three Compare fields that hold the value of which is the field to compare the base with. One example is below

e. Create Difference in % field for each compare field. An example is provided below

f. Final result will be like this

g. Test and fine tune the calculated fields

Hope this helps.

[HHXIAO]

Thank you sooooo much Giridhar.Prabhu! Really helped!