How to create a Last Month label?

[jim_chan]

Hi guys,

I have created the tablebox, now i need that label to state as Last Month Jan/Feb/Mar..... so on.

For example, if i have click on April, that column will show March figure, i need the label to be Last Month March.

I have below expression. but didnt seem to work.

='Last Month' & Month(addmonths(max(Month) ,- 1))

Rgds,

Jim

[kaushiknsolanki · Accepted solution]

Hi,

You can try this.

='Last Month' & Month(addmonths(max(Date) ,- 1))

Regards,

Kaushik Solanki

[Chanty4u]

try wit max date

='Last Month' & Month(addmonths(max(Date) ,- 1))

[Chanty4u]

or else

='Last Month' & Num(Month([ Date]))-1)

or

LastMonth = max(Month)-1

and then:

='Last Month' & sum({$<Month={$(LastMonth)} >} Sales)