Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Can someone help me in one query
I want one expression into another expression.
=sum({<Year=,Month=,monthyear={">=$(=max(monthyear)) <=$(=addMonths(max(monthyear),4))" }>}fieldA)/5*fieldB
Above is my first expression and i want my this calculation into below expression
=Sum({<Item = {"=Rank(Sum(fieldB))<=30"}>} fieldB) // For top 30 Items
Actually i want top 30 items but based on my first expression calculation.
Is this possible?
If yes then how??
Thanks
Hi,
Try like this
=sum({<Year=,Month=,monthyear={">=$(=max(monthyear)) <=$(=addMonths(max(monthyear),4))" },Item = {"=Rank(Sum(fieldB))<=30"}>}fieldA)/5*fieldB
Thanks,
Deva
Thanks for your help.
This expression is working but showing all items instead of selecting only 30 items.
How to restrict it for showing only top 30 items?