Grand Totals with Nested Sub Totals
Personally, I happen to agree. However, the fact is that before applying the
patch, I saw the evidence that a separate Grand Total was created for each
separate sub-total that was run. The user wants to know why that is
different after the patch.
My intuition tells me it was incorrect the way it originally worked and it
was 'fixed' with the patch. The user wants me to find out why it was changed
if possible.
Thank you for your input.
--
Brenda
"Tyro" wrote:
A Grand Total is just that. One total for the numbers above it. That's why
it's called a "Grand Total". As in: 5, 3 Subtotal 8. 4, 7 Subtotal 11. Grand
Total 19
Why would you want to see: 5, 3 Subtotal 8. 4, 7 Subtotal 11. Grand Total
19. Grand Total 19
Tyro
"Brenda from Michigan" wrote
in message ...
User has Excel 2002 (10.6834.6830) SP3
We have applied patch KB892097 and have done a Registry fix that this
patch
appears to require.
Problem: Before this patch was done to correct the way Sub Totals work,
the
client would do 5-nested sub totals and Excel would put 5-Grand Total rows
at
the bottom, all with the same number. Since the patch, there is only one
Grand Totals row at the bottom. Is this working as designed? Why the
change?
Thank you for any responses.
--
Brenda
|