Year wise Last month Sales

[sreeni_qvd]

Hi All,

I wrote this expression, If select any year, I am getting  complete month wise sales (Possible months).

Sum({$<Year = P({1<Year={$(=Only(Year))},MonthNo ={$(=max(MonthNo))}>})>}Sales)

But I am expecting. If I select any Year, In that year what is the last month Sales only.

Regards:

Sreeni

[PrashantSangle]

Hi,

Try,

Sum({<MonthNo={"$(=max(MonthNo))"}>}Sales)

Kind Regards

[sunny_talwar · Accepted solution]

Have you tried this:

Sum({$<MonthNo ={$(=Max(MonthNo))}>}Sales)

[MK_QSL]

=SUM({<InvoiceYear = {'$(=Max(InvoiceYear))'}, InvoiceMonth = {"$(=Month(MakeDate(Max(InvoiceYear),Max({<InvoiceYear = {'$(=Max(InvoiceYear))'}>}InvoiceMonth))))"}>}Sales)

Chagne InvoiceYear and InvoiceMonth to your respective field names.

[sasikanth]

try some thing like,

create YearMonth field and use that field in set expression

sum({<YearMonth={$(=max(YearMonth))}>} Sales)