rollup in 8.1.5 (sums at top?)

From: L8tr0n <l8tr0n_at_my-deja.com>
Date: Wed, 09 Feb 2000 20:46:46 GMT
Message-ID: <87sjnk$uco$1@nnrp1.deja.com>

I have been using the rollup grouping in 8.1.5

It makes nice little subtotals for me..

YEAR REGION SUM(PROFIT) COUNT(*)
---------- ------- ----------- ----------

      1995 Central         100          1
      1995 East            200          2
      1995 West            200          2
      1995                 500          5
      1996 West            200          2
      1996                 200          2
                           700          7

See how the sub totals are inserted after the detail the "normal way" Well I need the grand total and the subtotals to come BEFORE the detail it is subtotaling. why? just cuz..
If I run a order by desc.. EVERYTHING is reversed.. meaning that the detail rows are also in reverse order.. I don't want this.. Is there ANY way I can achieve this result?

YEAR REGION SUM(PROFIT) COUNT(*)
---------- ------- ----------- ----------

                           700          7
      1995                 500          5
      1995 Central         100          1
      1995 East            200          2
      1995 West            200          2
      1996                 200          2
      1996 West            200          2

Suggestions?

-Ken

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Feb 09 2000 - 14:46:46 CST