Adding Current year Max Month with previous year max month?

[DS14]

Hi Experts,

I want to add current year Max month value with previous year max month value(means 12th month).

for ex:

I selected financial year 2019-2020(Apr-May)

i want to add ---Mar-2019+currnt year Max month(May value)

How to pick the previous year Max Month value when i selected current year.

Note: I don't have the date field in the table, have only Month and Year like march'19, April'19.

Urgent plz help on this.

Thanks,

[DS14]

Hi Experts,

I want to add current year Max month value with previous year max month value(means 12th month).

for ex:

I selected financial year 2019-2020(Apr-May)

i want to add ---Mar-2019+currnt year Max month(May value)

How to pick the previous year Max Month value when i selected current year.

Note: I don't have the date field in the table, have only Month and Year like march'19, April'19.

Urgent plz help on this.

Thanks,

[dplr-rn]

First things first. create a date field with what you have e.g. March 19 becomes 1 March 19
You can use set analysis to achieve what you want.

[DS14]

Hi Dilip,
Thanks for quick response .
What will be my expression after creating calendar, what I have to mention in set analysis.