Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to select only record with highest total?

I have a list of records with date and total as below:

Date Total

3 May 0

5 May 2

5 May 3

5 May 8

6 May 2

6 May 4

If i only want to select records with highest total for each date, how would l do the record selection?

This is what i want to do:

Date Total

3 May 0

5 May 8

6 May 4

Appreciate some feedback. Thanks.

Former Member
replied

Hi,

If you can change the running total to a formula then summarize that formula, you can do a Top N sort or Group Selection Formula on the summary.

Running totals don't allow very much flexibility after they are generated.

Good luck,

Brian

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question