Top 10 in an Expression

[mohfaraj]

Hallo all together,

I want to see the top 10 (Costumers) in total Volume. I want to integrated as an example in this expression (=sum ({$<Jahr={2017}>}[_LE_MainVolume]))

I tried to make a set analysis for this expression just to add choosing the top 10 main volume of the customer in 2017..... Can you help People ?

Thanks

Mo

[vishsaggi]

May be this?

= sum ({$< Jahr={2017}, [_LE_MainVolume] = {"=Rank(Sum(_LE_MainVolume),4) <11"}  >} [_LE_MainVolume])

[sunny_talwar · Accepted solution]

I think it should be this

=Sum({$<Jahr = {2017}, Costumers = {"=Rank(Sum(_LE_MainVolume),4) <11"}>} [_LE_MainVolume])

[mohfaraj]

this was correct thanks. One question, for stands the (4) in the equation

[mohfaraj]

for what *