Report Definition : Return rows containing max value | Collaboration Center

Contact a Moderator

Question

1

Replies

590

Views

Member since 2018

Swedbank AB

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***

Enterprise Application Development

Dev/Designer Studio

PEGA

replied to TaurasS8

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