Select Top % Dimension based on Measurement in Filter Pane

[Architect]

Data be like-

DIM1	sales
A	12
B	11
C	32
A	22
C	21

Hi,

I need to Find out top 2 Dimensions based on the Sales (sum(sales)). and need to show these two top Dimensions.

Top 2 Dimensions

A

C

[randomuser]

Hi,
You can try use this expression =if(aggr(rank(sum(sales)),dim1)<=2,dim1) on data dimensions in filter pane.

Regards