Consulting

Results 1 to 2 of 2

Thread: Solved: multiple subtotals problem

  1. #1
    VBAX Mentor ALe's Avatar
    Joined
    Aug 2005
    Location
    Milan
    Posts
    383
    Location

    Solved: multiple subtotals problem

    Hi all, I can't figure it out.

    I'm doing subtotals on a table and they don't work: half a table is ok, in the second half subtotals are displayed in the wrong column and on wrong groups.

    To understand have a look at the sample file.
    First subtotal is on the field "Categoria" by sum of "VAL12";
    Second subtotal is on the field "Modello" by average of "VAL12".

    Once subtotals are applied the level 2 is not working as shown in the image "error" (next post)

    I've found there's a bug in excel 2002/2003 about multiple subtotals(the are displayed in wrong order) but I don't think it's my case.
    http://support.microsoft.com/kb/831824/

    Any idea?
    Thanks

    EDIT: sorry I had to remove attachment due to privacy. Actually I installed SP1 and the error vanished.
    Last edited by ALe; 02-08-2008 at 04:03 AM. Reason: privacy
    ALe
    Help indigent families: www.bancomadreteresa.org

  2. #2
    VBAX Mentor ALe's Avatar
    Joined
    Aug 2005
    Location
    Milan
    Posts
    383
    Location

    error

    error image

    EDIT: image removed due to privacy issue
    Last edited by ALe; 02-08-2008 at 04:04 AM. Reason: privacy
    ALe
    Help indigent families: www.bancomadreteresa.org

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •