Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
raju_salmon
Creator II
Creator II

Set Analysis Modifier Issue

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.

1 Solution

Accepted Solutions
sunny_talwar

Try this:

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

View solution in original post

5 Replies
MK_QSL
MVP
MVP

Hope you have defined your variable as below

vMaxYear

Max(Year)

i.e. without = sign in Variable Overview

swuehl
MVP
MVP

Please post your definition of vMaxYear.

You can also try

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

raju_salmon
Creator II
Creator II
Author

I have created variable

LET vMaxYear =Year(Today();

sunny_talwar

Try this:

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

MK_QSL
MVP
MVP

Remove This vMaxYear from script

Go to variable overview

create variable as

Name

vMaxYear

Max(Year)