ignore selection in firstsortedvalue()

[anson_kong]

hi all,

If I click the selection 'Store A', the Text Value in StoreB and StoreC is changed to null.

I would like to ignore the selection (Store) in my expression ,

the existing formula

=firstsortedvalue(TextValue,-(aggr(sum(Amount),Store,TextValue)))

Store	Text Value
A	hjk
B	oiu
C	qwe

thank you

[agigliotti · Accepted solution]

let's try as below:

=firstsortedvalue( {< Store= >} TextValue,-(aggr(sum( {< Store= >} Amount),Store,TextValue)))

[YoussefBelloum]

Hi,

try this:

=firstsortedvalue(TextValue,-(aggr(sum({<Store>}Amount),Store,TextValue)))

[anson_kong]

it works

thank you

[agigliotti]

please close the thread marking the answer as correct to help other people.