How to make modifiers of set expression dynamic ?

[shekhar_analyti]

Hi All ,

How to make modifiers of set expression dynamic ?

I have two fields called Entityand SubArea .

My expression should be something like ;

sum({1<Field_of_My_choice={'A'}>}sales) .

Script

LOAD Area,

     Entity,

     Sales,

     SubArea

FROM

[Dynamic Modifier.xlsx]

(ooxml, embedded labels, table is eNTITY);

Fields:

LOAD * INLINE [

    Field

    Entity

    SubArea

];

I have solved this using pick match , though . But wanted to know if there is other way !!!

[shekhar_analyti]

Field of my choice means user has ability to select modifiers

[Clever_Anjos · Accepted solution]

Please try with

sum({<$(=Only(Field))={'A'}>}Sales)

[shekhar_analyti]

Though   sum({<$(=Only(Field))={'A'}>}Sales) worked but curly bracket before 'A' is having some red highlighted

[shekhar_analyti]

[Clever_Anjos]

it´s not a problem.

The parser editor isn´t understanding what we are trying to do.

Keep calm, it will work

[shekhar_analyti]

Thank you Anjos