Using GetFieldSelections in set analysis

[Anonymous]

Hi All,

I have a dashboard with [Month] as a filter. Only one value for [Month] can be selected at a time.

I'm using the code:

sum({<TransitionMonth=${"=GetFieldSelections(Month)"} , Version={'ABC'}>}Value)

and with 'Aug' filtered for [Month], I'm getting the 4th column in the below table:

What I need is for each row to give me the value of 2.2, since that is value for [TransitionMonth]=[Month]=Aug.

What am I doing wrong?

[Anonymous]

Sorry, didn't get you.

[OmarBenSalem]

Under adds on, uncheck zero values:

[YoussefBelloum]

Uncheck this checkbox like this

[Anonymous]

Hey, it's okay. It wasn't exactly what i wanted but  I could get this one to work for the overall code. Thanks!

[YoussefBelloum]

you're welcome !

don't forget to close the thread by marking the helpful and the correct answers.

[Anonymous · Accepted solution]

This worked!

sum(total{<TransitionMonth={'$(=getfieldselections(Month))'} , Version={'1YP'}>}Inflows)*change/100

It was missing a TOTAL function

[YoussefBelloum]

But with this, before you select your Month, each time, you will have the TOTAL on each line !

Is that what you want ?

[Anonymous]

Yes. That was what I wanted. This is a part of a bigger code, and I have an If-Else to handle this.

[YoussefBelloum]

Perfect, good luck