sum({1<year={2013}>}sales)

[d_koti24]

my data consists 4 years like 2010,2011,2012,2013

in set analysis how can   i use max(year) instead of year={2013}.....

i am using this below expr

sum({1<Year={(=max(Year))}>sales)

i am getting error.......how can resolve this ?

[MK_QSL]

SUM({<Year = {'$(=Max(Year))'}>}sales)

or

SUM({1<Year = {'$(=Max(Year))'}>}sales)

[its_anandrjs]

Try with

sum({< Year = {'$(=Max(Year))'} >} sales)

[Anonymous · Accepted solution]

... or

sum({1<Year={"$(=max({1} Year))"}>} sales)

If you want max year to be independent from selections

[d_koti24]

my reqiurement is i want to get

2013,and 2012 or 2011 or 2010(current selection) total sales.....

i want to compare the sales with  2013....

i am using this expr (sum({1<year={2013}>}sales)) i am getting correct o/p..instead of this expr using

SUM({1<Year = {'$(=Max(Year))'}>}sales) this , iam getting all 4 yrs total in 2013 field....

[MK_QSL]

SUM({<Year *= {'$(=Max({1}Year))'}>}sales)

or

=SUM({<Year = {'$(=Max(Year))','2013'}>}Sales)

[its_anandrjs]

Try with this way

sum({< Year = {'$(=Max(Year))', '$(=Max(Year)-1)'} >} sales)

Or

sum({< Year = {"$(=Max(Year))", "$(=Max(Year)-1)"} >} sales)

If you want max and last max years like 2013 and 2012

[Anonymous]

Try with this:

SUM({<Year={'$(=Date(max(Year),'YYYY')'}>}sales)

[d_koti24]

thank u