Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello together
I have a column with operations and articles. Each item has several operations. Now I want to filter the highest operation for each item. I have already made tests with "max(operation)" as filter, unfortunately without success.
Below is an example:
I only want to see the operation 70 of the article "y", but I do not want to set the filter to fixed 70, but to the highest operation per article.
Thanks already
| Operation | Article | Order |
| 30 | y | a |
| 70 | y | b |
| 30 | x | c |
| 30 | x | b |
| 70 | y | a |
Like this?
Aggr(Max(Operation),Article)
Hi @BrunPierre,
Your solution seems to be working. Would request @MauStrQua to test it out and confirm.