jesperengel
Technical User
Using CrvXI
I have a report with 3 groups. I have made a running total (Total shots), which evaluates every record and resets after change of Group 3. It gives me something like this:
Player Club Ball Total Shots
Jack Titleist Titleist 1
2
3
4
Thomas Titleist Titleist 1
2
3
4
5
What I want is the maximum number in each combination i.e.
Player Club Ball Total Shots
Jack Titleist Titleist 4
Thomas Titleist Titleist 5
How is this best done??
I have tries doing a Maximum on the Running Total, but was not allowed to do this.
Thank you!!
I have a report with 3 groups. I have made a running total (Total shots), which evaluates every record and resets after change of Group 3. It gives me something like this:
Player Club Ball Total Shots
Jack Titleist Titleist 1
2
3
4
Thomas Titleist Titleist 1
2
3
4
5
What I want is the maximum number in each combination i.e.
Player Club Ball Total Shots
Jack Titleist Titleist 4
Thomas Titleist Titleist 5
How is this best done??
I have tries doing a Maximum on the Running Total, but was not allowed to do this.
Thank you!!