Issue with Variable in Set Analysis

[#1]

Hi,

I have the below variable defined:

DY= $[Year] (current selection of the Year)

Set Analysis:

Sum({$< [DIVERSITY DEFINITION]={'SMALL BUSINESS'}, [DIVERSITY YEAR]={$(DY)}>}[Line Amount])

The outcome seems to not work at all. Any help will be much appreciated.

Thank you!

[shraddha_g]

Try:

DY= getcurrentfieldselection(Year)

Set Analysis:

Sum({$< [DIVERSITY DEFINITION]={'SMALL BUSINESS'}, [DIVERSITY YEAR]={'$(DY)'}>}[Line Amount])

[stabben23]

Hi,

try this without variable.

Sum({$< [DIVERSITY DEFINITION]={'SMALL BUSINESS'}, [DIVERSITY YEAR]={$(=max(Year)) }>}[Line Amount])

[sunny_talwar]

May be this:

Sum({$< [DIVERSITY DEFINITION]={'SMALL BUSINESS'}, [DIVERSITY YEAR]={$(=DY)}>}[Line Amount])