Top dimension values in tables

[thakurj]

Hi,

Is it possible to make the top values of a certain dimension in a table based on multiple measures.

Ordinarily, the top values of the dimension are based on the first measure. I want the user to be able to choose the measure on which the top values of the dimension should be based. 

eg. with a click of a button, the user should be able to toggle between top 10 products with highest sales and top 10 products with highest profit.

[theoat]

Hello
Yes, this is available by doing set analysis in your measurements. Inside it, you can select the top 10 of the dimension according to the chosen metric (depending on the button clicked, the value of the variable differs).
I can possibly give you a little demonstration with an easy use case.

Kind regards
Theo ATRAGIE.

[thakurj]

@theoat Could you please show the demonstration with the use case

[theoat · Accepted solution]

First, create a variable with an initial value of 0.

Next, add two buttons. One for your first metric (Turnover), and one for your second (Sales Volume). Clicking the first button sets the variable to 0. Clicking the second button affects the value 1.

Next, make a conditional measurement. Depending on the value of the variable, this will be one measure or the other that will be calculated.

Next, add your dimension, and add the top 10 limitation.

And voila, the graphic adapts to the button clicked.

Top 10 products by Turnover :

Top 10 products by Sales volume.

Kind regards,
Théo ATRAGIE.