how to show last month data with current month selection

[#1]

how to show last month data with current month selection ????

[sushil353]

=sum({<month={">=$(Max(Month)-1) <=$(Max(Month))"}>}value)

[somenathroy]

{<Date={'$(=Max(Date))'}>}

[where Date is Calendar Date of the selected month]

or you may use

{<TDate={'$(=Max(TDate))'}>}

[where TDate is Transaction date of the selected month]

Regards,

Som

[jagan]

Hi Vignesh,

If you have a date field in your table then use this

=Sum({<MonthField=, DateField={'>=$(=MonthStart(Max(DateField), -1))<=$(=MonthEnd(Max(DateField), -1))'}>} Sales)

Hope this helps you.

Regards,

Jagan.

[#5]

Hi

use the addmonths function

AddMonths(START_DATE,-1)

use this in ur expr tab

it works

[neha_shirsath]

Hi Vighnesh,

Try this Expression-

=sum({<Year={$(=max(Year))},Month={$(=month(addmonths((max(Date)),-1)))}>}Sales)

Regards,

Neha