Unable to Calculate Top records

[Karim_Khan]

Hi Team,

   I am unable to calculate Top 5 Customers.I have applied the following expression in

=AGGR(IF(Rank(sum([Net Bookings]), 4)<=5, [End Customer Global Ultimate Name]),[End Customer Global Ultimate Name])

and I have applied

=sum([Net Bookings])

Its getting calcuated but By default Month is getting Pick in Second expression.

=sum([Net Bookings])

If I want to chnage the same by Applying month its not capturing the Month field in Expression pls suggest

Regards,

K K

[swuehl]

Sorry, I don't understand your description. Could you post a small sample QVW?

[Anonymous]

Hi,

you can use [End Customer Global Ultimate Name] as dimension and sum([Net Bookings]) as the expression.

Then, in Dimension limit tab check "Restrict which values are displayed......" and the option "Show only" largest 5 values.