Maxyear sales amount using variable in set anaysis

[#1]

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

[sunny_talwar]

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)

[Anonymous]

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

[#4]

Thanks

It's working

[Anonymous]

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

[#6]

HI

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

It;s the answer it's working

Thiru