Show data of Top 10 values

[VaishnaviMogal2]

Hi,

I want to display data of top 10 VIN. As all fields in table are dimensions the limitation feature in disabled in chart. how can i achieve this using set expression or other ways.

thank you.

[Antoine04]

Hello,

Can you please share a sample of your DATA ?

One of the way you can try is to use the function Rank() as a mesure.

Regards

Antoine

[BrunPierre]

Something like this?

=If(Aggr(Rank(Sum(Value)), VIN) <= 10, VIN)