Set Analysis Modifier Issue

[raju_salmon]

Hi,

Though i have gone through the set analysis material, for below case i cannot able to write the expression.

By defaults, sales should be display for latest year

Sum({$<Year={$(vMaxYear)}>}Sales)

Whereas if i select any other year, then filtering should be done.

Any suggestions please.

[MK_QSL]

Hope you have defined your variable as below

vMaxYear

Max(Year)

i.e. without = sign in Variable Overview

[swuehl]

Please post your definition of vMaxYear.

You can also try

=Sum({<Year = {$(=max(Year))}>} Sales)

[raju_salmon]

I have created variable

LET vMaxYear =Year(Today();

[sunny_talwar · Accepted solution]

Try this:

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

[MK_QSL]

Remove This vMaxYear from script

Go to variable overview

create variable as

Name

vMaxYear

Max(Year)