Top 5 of difference between two measures

[former_member203128]

Hello experts!

I want to know how I can obtain a visualization that give me the difference between a measure separated  per year but only the first fives calculated amounts

For example, I have an amount of sales per year per client, and I just need the top 5 clients that increment this amount in that years

In Lumira I just can obtain the top 5 clients by the amount not by the difference of this amounts

Can you help me?

Regards

Alvaro

[shankarsgs]

Hi Alvaro,

Did you try creating a new Calculated measure that gives the result of Sales for all the years and then use that to get the Top 5 clients if you intend to get this result.

Regards

Shankar