Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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...
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...
Thank You so Much