5 Replies Latest reply: Jun 3, 2016 5:50 AM by Thiru Palu

# Maxyear sales amount using variable in set anaysis

Hi

I have a scenario

I want to show max year and month sales

created a varable vmaxyear for max year and month

please provide the set analysis ex[ression for do this

Thanks

Thiru

• ###### Re: Maxyear sales amount using variable in set anaysis

May be this:

Sum({<Year = {\$(=Max(Year))}>}Sales)

or this:

Sum({<Date = {"\$(='>=' & Date(MonthStart(Max(Date)), 'DateFieldFormatHere') & '<=' & Date(MonthEnd(Max(Date)), 'DateFieldFormatHere'))"}, Year, Month, MonthYear>}Sales)

• ###### Re: Maxyear sales amount using variable in set anaysis

Sum({<Year = {'\$(=vmaxyear)'}>}Sales)

• ###### Re: Maxyear sales amount using variable in set anaysis

Thanks

It's working

• ###### Re: Maxyear sales amount using variable in set anaysis

Hi.. Please mark the answer as correct or Helpful so that other members in the community could benefit and the status will change to answered...

Thanks

• ###### Re: Maxyear sales amount using variable in set anaysis

HI

Sum({<Year = {'\$(=vmaxyear)'}>}Sales)