Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts
I have an Calculated Expression in a straight Table [Last Month sale] - [Current month sale]
Now I want to choose only top 200 values based on my Customer Number dimension
Please Suggest
Hi,
In Straight table->property->Dimension Limit->Restrict data->Show Largest enter 200
Or
You can use Rank() also.
Regards
Hi...
Try like this expression.
=IF(Aggr(Rank([Last Month sale] - [Current month sale]),CustomerNo)<=200,([Last Month sale] - [Current month sale] ))
I hope this will help you
Thanks
HI Max
I am calculating Drift the formula for that is [Last Month sale] - [Current month sale]
So i want Max 200 in Drift
Hi,
You can do this using Dimension Limits. First sort your expression and make sure your expression is given the first priority. Then go to Dimension Limits tab and select Largest 200.
HI Amarnath I am getting Null Values for all
Is [Last Month sale] and [Current month sale] fields or expressions?
Hi,
You want top 200 Customer Number which have max drift
Then try my earlier solution or you can also try Amarnath Solution.
Regards
HI Deepak
[Last Month sale] is a Calculated Field
[Current month sale] is also a Calculated Field
Now I want to Calculate another field Drift
the formula for that is [Last Month sale] - [Current month sale]
Hi Max I tried it
But not able to get the desired result