8 Replies Latest reply: Apr 17, 2018 7:04 AM by Sasidhar Parupudi

# max Year Month

hello,

I want to show max month on the line chart.

I am Using this formula and its not Working and can you please advise me something.

sum({\$<Year = {\$(=max(Year))}, Month = {\$(=max(Month))}>} FactSoldAmount)

• ###### Re: max Year Month

Try this

Sum({\$<Year = {\$(=Max(Year))}, Month = {'\$(=Max(Month))'}>} FactSoldAmount)

• ###### Re: max Year Month

hi, It doesn't work without selection. If I select 2018 or another year it is correct but Without it it Doesn't Show anything

• ###### Re: max Year Month

Hi,

As sunny said the above expression will work fine . Can you share your app to check

• ###### Re: max Year Month

I think you need to use date field to filter you data rather than using year and month fields

• ###### Re: max Year Month

Hi, This is my calendar.

Calendar:

Distinct

%lnk_date,

Date(%lnk_date) as Date,

Day(date) as day,

year(%lnk_date) as Year,

month(%lnk_date) as Month,

'Q' & ceil(month(%lnk_date)/3) as Quarter,

'Q' & ceil(month(%lnk_date)/3)  & '`' &  right(year(%lnk_date),2)  as [Year Quarter],

ceil(month(%lnk_date)/3) as %QuarterNum,

month(%lnk_date)  & '`' &  right(year(%lnk_date),2)  as [Year Month] ,

year(%lnk_date)*100 + month(%lnk_date) as %ym

Resident  GasOperatingSales;

• ###### Re: max Year Month

May Be try

Sum({\$<Year =, Month = , [Year Month]={"\$(=Max( [Year Month]))"}>} FactSoldAmount)

• ###### Re: max Year Month

Would you be able to share a sample or some sample data to look at this?