Set Analysis,Aggr,Rank Help

[Surya]

Need Help to write an expression

I get using dimension limits largest 10 Customers in expression i taken max (year) sales

now i have top 10 customers in 2019

same customers performance in 2018 so i want 

same customer Sales of 2017 and 2018

for example 2019 top 5

surya

prakash

talwar

vinayk

ravi..

i need same person sales in 2017 and 2018

[tresesco · Accepted solution]

Try using p(), something like:

Sum({<[Order Year]={2017,2018},[Customer Name]=p({<[Customer Name]={"=Rank(Sum({<[Order Year]={2019}>}Sales))<=5"}>})>}Sales)

You might have to tweak the expression a bit according to your exact requirement, like dynamic year calculation in set rather than hard coding them...

[Surya]

Thank You so Much