Dollar Sign Expansion of Only with several values.

[#1]

Hi Community,

Is there away to do set analysis dollar sign expansion of an "Only(" for several values.  Basically, I want to do the following with several years like 2012, 2013,

sum({$<Year = {$(=Only(Year))} >} LineSalesAmount)

or

sum({$<  Year = {$(=$(vCurrentYear))}> } LineSalesAmount)

Again, I want to use one of the above but have it for seveal years and not just one.

[Oleg_Troyansky · Accepted solution]

you can have a number of values, each one represented by its own $-sign expansion, separated by comma:

For example:

sum({$<Year = {$(=Only(Year)), $(=Only(Year)-1), $(=Only(Year)+1)  } >} LineSalesAmount)

[SunilChauhan]

use below

sum({$<Year = {$(=max(Year))} >} LineSalesAmount)

hope this helps

[#4]

Wonderful!  Thank you, thats very helpful!