top n values in current month comparing to previous month

[#1]

Hi All

please help me out in

Comparing the current month top  n values to the previous months

[johnw]

Just a typo, perhaps. You're doing sum(country) instead of sum(Orders).

[ecolomer]

As John, say you need change Country by Orders

[#4]

Hi john i tried the other  way as well but no luck

Can u pls help me

[#5]

I didnt get that can you pls explain

[ecolomer]

In your expression you have "country" and is "orders"

[#7]

Its not geeting yhe correct results

[tresesco]

Perhaps like this:

sum({<country={"=rank(Sum({<OrderDate={'>=$(MonthStart(Max(OrderDate))))<=$(=Date(Max(OrderDate)))'}>}Orders))<4"},

OrderDate={'>=$(MonthStart(Max(OrderDate),-2)))<=$(=Date(Max(OrderDate)))'}>}Orders)

[Aurelien_Martinez]

Hi,

Try this expresion : sum({<country={"=rank(aggr(Sum(Orders), country), 4, 1)<=3"}>} Orders)

Aurélien

[johnw]

When I fix the expression as I suggested, I get the results you requested. The only difference I see is they aren't sorted in the order you show. If that's important to you, sort your second dimension like this:

rank(sum({<MonthYear={"$(=max(MonthYear))"}>} Orders),4,1)

I think you can also just use this as your expression:

sum(Orders)