Hi;
I have encountered a strange problem with the subtotal function. I am trying
to create 3 levels of subtotals, which works fine except that it messes up
the first groupings.

I have following source data and would like to have subtotals by Customer
Group, Projecttype and Project Group.

Customer Group Projecttype Project Group Project Revenue
C Group A Projecttype A Group A Project 1 500
C Group A Projecttype A Group A Project 2 600
C Group A Projecttype A Group A Project 3 700
C Group A Projecttype A Group B Project 4 800
C Group A Projecttype A Group B Project 5 900
C Group B Projecttype A Group A Project 1 500
C Group B Projecttype A Group A Project 2 600
C Group B Projecttype A Group A Project 3 700
C Group B Projecttype A Group B Project 4 800
C Group B Projecttype A Group B Project 5 900
C Group C Projecttype A Group A Project 1 500
C Group C Projecttype A Group A Project 2 600
C Group C Projecttype A Group A Project 3 700


I select the source data and choose the subtotal function in Excel with the
options: At each change in Customer Group, Use function sum, Add subtotal to
Revenue, none of the checkboxes are clicked and click Ok. Everything works
as expected at this point.
Then I choose subtotal function a second time, this time I choose the
options: At each change in Projecttype, Use function sum, Add subtotal to
Revenue, none of the checkboxes are clicked and click Ok.

When I now collapse the data and display the first three levels I see
following:

Customer Group Projecttype Project Group Project Revenue
Projecttype A Total 3500
Grand Total 8800
C Group A Total 3500
C Group B Total 3500
Projecttype A Total 3500
C Group C Total 1800
Projecttype A Total 1800


You can see the Grand Total appears after the Projecttype A group. I would
have expected the Projecttype A Total to appear after C Group A Total.

Do I do something wrong, or is this a bug in EXCEL?

Any help is greatly appreciated

Thomas Born
)