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.