Report Definition : Return rows containing max value
Hello,
I would like to ask how to configure report definition that would return only the rows containing max value based on one column.
Example:
C | 15 | TT
B | 18 | TT
C | 18 | TT
My query should return 2nd and 3rd rows.
***Edited by Moderator: Pallavi to update platform capability tags***
Posted: 1 year ago
Hello
Try using the
summarize option = Max
Here is a good post to check : https://community1.pega.com/community/pega-product-support/question/get-max-number-data-table-and-assign-it-property