Question
1
Replies
590
Views
Posted: April 3, 2019
Last activity: April 10, 2019
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***
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