Expression for Sorting the data in straight table chart

[raghavsurya]

Hi All,

We have defined a variable for product and calculating the what-if scenarios only for the product selected in the input box linked to the variable.  The straight table chart contains around 13k products and its sales details.  The increase/decrease in sales applies to only the product selected in input box and its getting changed as per expectations. 

But we need the products selected in the inputbox to be displayed first in the table.  Can you please suggest how to do it.

Regards,

Raghav

[yasus]

Hi Rahav,

you can use the sort ascending/descenting function with reference to your increase/decrease expression in the properties of your chart.

The results will be either at the top or at the bottom of the table afterwards.

[#3]

I dont know whether I got you or not if I'm wrong just correct me and help me to understand the problem ...

Try to sort with the expression in asc/desc format and unselect the alphabetical order to sort 

Go to chart properties and go to sort tab there you can change it

Thanks 

Brad

[syed_muzammil]

Hi,

In the Properties->Sort->By Expression , write the following expression.

If(Product=Variable,1,2).

It will automatically show the Variable product selected as the first product in the table.

[raghavsurya · Accepted solution]

Thanks Syed.... your suggestion helpmed us a lot