Closed
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: 5 years ago
Pegasystems Inc.
IN
Hello
Try using the
summarize option = Max
Here is a good post to check : https://collaborate.pega.com/discussion/get-max-number-data-table-and-assign-it-property