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.
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.