
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sum FirstSortedValue for Groups
Hello,
I am new in the community and hope you can help me. I have a table with article numbers, storage locations and quantities.
I would like to sum the values from the last date regarding the article number and the storage location. I can't get it to work.
I tried to sum with FirstSortedValue(Menge, -Datum). But unfortunately it doesn't work.
I hope you can help me. (Lager = Storage Location, Menge = Quantity)
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Check this out
write this in your measure and also check the attachment it is the desired output.
FirstSortedValue(Aggr(Sum(Quantity),ArticleNumber,StorageLocation),-Date)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
Check this out
write this in your measure and also check the attachment it is the desired output.
FirstSortedValue(Aggr(Sum(Quantity),ArticleNumber,StorageLocation),-Date)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hello,
thank you for your help. It works 🙂
