Ranking by top 10 in Widget

[KHConsult]

I have a dashboard widget that displays a Column Chart. I only want to show the top 10 highest amounts within the chart and also rank from highest to lowest (left to right). 

I added a filter and brought in the data that I want to rank by. It pulled in the top 10, but they are in no particular order. 

Thank you. 

[Angelina_QBeeQ]

Hi @KHConsult ,
You can set sorting for your value here:

Always here to help,
Angelina from QBeeQ
[email protected]
QBeeQ - Gold Implementation and Development Partner

[SvenKolodzey]

Hi @Angelina_QBeeQ ,

how should I filter for Top N in case my dataset is already exceeding the shown 10k limit? In this case I run into high memory consumption on a specific widget.

Where would you suggest should I reduce data for the widget (I can't do this in the CUBE) and reducing the timeframe by filter doesn't help and filter relationships only seem to work on dashboard filter.

Thank you