PDA

View Full Version : Solved: multiple subtotals problem



ALe
02-07-2008, 05:37 AM
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/ (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.

ALe
02-07-2008, 05:38 AM
error image

EDIT: image removed due to privacy issue