Automated selection of Maximum month from selected Year

[P_Kumar]

Hi,

I have a requirement to show the Maximum month (December)  'Sales Revenue' for the corresponding Year selected from filter box.  There might also be a case where user select multiple years and then the selected year's Maximum month's (i.e. December) data should be displayed. Kindly advise.

[y_grynechko · Accepted solution]

Hey,

did you try to create Month-Year column in calendar and use max function? 

I do it this way: 

(Date(monthstart(Your Date), 'MMM-YY')) as MonthYear

And later on in the app use this to get max month data: 

sum({$<MonthYear ={"$(=Max(MonthYear))"} >}Sales)

[Anil_Babu_Samineni]

Can't you simplify using this?

sum({$<MonthNum={"$(=Max(MonthNum))"} >} Revenue)

[y_grynechko]

Seems the same, depends on what you create in the calendar.