Choosing Max 200 in Expression

[#1]

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

[PrashantSangle]

Hi,

In Straight table->property->Dimension Limit->Restrict data->Show Largest enter 200

Or

You can use Rank() also.

Regards

[prajapatiamar38]

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

[#4]

HI Max

I am calculating Drift  the formula for  that is [Last Month sale] - [Current month sale]

So i want Max 200 in Drift

[Anonymous]

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.

[#6]

HI Amarnath I am getting Null Values for all

[IAMDV]

Is [Last Month sale] and [Current month sale] fields or expressions?

[PrashantSangle]

Hi,

You want top 200 Customer Number which have max drift

Then try my earlier solution or you can also try Amarnath Solution.

Regards

[#9]

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]

[#10]

Hi Max I tried it

But not  able to get the desired result