Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 24, 2010 at 07:17 AM

    you can have this directly in your query

    select date, max(total)

    ...

    group by date

    as every report is based on the query

    Add comment
    10|10000 characters needed characters exceeded

    • 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