View Single Post
  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

The problem is supposed to be corrected by installing this hotfix:

http://support.microsoft.com/default.aspx?id=833855

You can visit this page on the Microsoft site, to check what Office
updates should be installed:

http://office.microsoft.com/en-ca/of...e/default.aspx



Thomas Born wrote:
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
)




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html