Previous month last date

[#1]

Dear All,

i want to add Previous month Last day sales and want to compare from current month Last day sales.

For example today is 29-2-2016 i want to extract  31-1-2016 date as well as sales of that date.

i have two fields one for 'Date' and other is 'Sales', i hope its clear now

[#2]

my desired result to get

first expression

South

31-Jan-16

40

second expression

South

15-Feb-16

1320

i want these numbers as result in table form.

[tresesco]

It's good practice to mark helpful/correct replies - that helps others searching for similar solution.

[Anonymous]

Did you try what I suggested you?

To get 15-Feb-16, just remove monthend() from my Current Month Expression

[tresesco]

PFA

=Sum({<Date ={"$(=Date(Max(Date)))"}>}Sales)

=Sum({<Date ={"$(=Monthend(Max(Date),-1))"}>}Sales)