Top 10 values

[#1]

I am creating a bar chart that is showing comparison between   Actual margin and Quoted margin for top 10 highest revenue giving products

Dimension limit restriction is not working because it restricts on the basis of first expression and my first expression is calculating margin

please suggest

Thanks in advance

[senpradip007]

Could you please upload sample qvw......

[arulsettu]

you can use rank function

[ecolomer]

See this example

[pradnyat]

Hi Prashant,

In dimension limit select 'Show Only first 10 values ' option for Product dimension .

In Sort, write your second expression in 'Expression' and sort it descending.

[agomes1971]

Hi,

my example use it freely

Regards

André Gomes

[Anonymous]

Hi Andre,

Try to use Expression sorting:

Best regards,

Janusz