Can you sort by a sum field?

building reports desktopintelligence
1

X-cc: “Davis, Vicki L.” VICKI.L.DAVIS@usa.conoco.com

I want to sort based upon an aggregate amount in a break footer. How do
I do this?

Greg Mills
Conoco Inc.
(580) 767-5597 ETN 442-5597
s-greg.mills@usa.conoco.com

Listserv Archives (BOB member since 2002-06-25)

2

In a message dated 99-01-07 11:43:18 EST, you write:

I want to sort based upon an aggregate amount in a break footer. How do
I do this?

Greg Mills

Greg:

Step 1: Click on the sum
Step 2: Click on the sort button on the toolbar

Ha, and you didn’t think that it would be that easy!

Seriously, since totals don’t show up in Slice and Dice it is not the most
obvious thing. You have to use the toolbar (or right click on the desired
item). Be aware that what will happen is that the break item will sort as a
unit. Which is probably what you want. In other words, if you create a report
block with Resort, Service Line, and Revenue, Break on Resort, Calculate on
Revenue… you can then Sort on the total Revenue for each Resort. The resorts
will be ordered in ascending (or descending) order of total revenue.

Regards,
Dave Rathbun
Integra Solutions
www.islink.com

PS - I miss the Rusty Barrel…

Listserv Archives (BOB member since 2002-06-25)

3 
    Step 1: Click on the sum
    Step 2: Click on the sort button on the toolbar

HA HA HA

I guess I should have been more explicit on EXACTLY what I was trying to
do.

What I was trying to do was sort a report by descending number of rows
for each high-level break.

OK Try this smarty britches. Select Country, Resort, Service, and
Revenue. Break and country and add a COUNT to the country column. Then
change the count to Count(RowIndex()). Then:

    Step 1: Click on the count
    Step 2: Click on the descending sort button on the toolbar

Any other suggestions on how to do what I actually want would be greatly
appreciated.

Greg Mills
Conoco Inc.
(580) 767-5597 ETN 442-5597
s-greg.mills@usa.conoco.com

Listserv Archives (BOB member since 2002-06-25)

4

Hi, Greg.

Create a variable defined with the following:
=Count(RowIndex()) In

Note that you have to create this as a variable; using a simple formula will
NOT work.

Cheers,
Luis Gonzalez

Listserv Archives (BOB member since 2002-06-25)

5 
    Note that you have to create this as a variable; using a simple

formula will
NOT work.

Thanks. All I did was click on the formula and define it as a variable
to solve the problem. THANKS!

Greg Mills
Conoco Inc.
(580) 767-5597 ETN 442-5597
s-greg.mills@usa.conoco.com

Listserv Archives (BOB member since 2002-06-25)