
Contributor II
2018-03-16
04:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ignore selection in firstsortedvalue()
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
1,417 Views
1 Solution
Accepted Solutions


Partner - Champion
2018-03-16
04:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
let's try as below:
=firstsortedvalue( {< Store= >} TextValue,-(aggr(sum( {< Store= >} Amount),Store,TextValue)))
4 Replies


Partner - Champion
2018-03-16
04:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
let's try as below:
=firstsortedvalue( {< Store= >} TextValue,-(aggr(sum( {< Store= >} Amount),Store,TextValue)))

Champion
2018-03-16
04:50 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
try this:
=firstsortedvalue(TextValue,-(aggr(sum({<Store>}Amount),Store,TextValue)))
1,344 Views

Contributor II
2018-03-16
05:04 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
it works
thank you
1,344 Views


Partner - Champion
2018-03-16
05:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
please close the thread marking the answer as correct to help other people.
1,344 Views
