sorting subtotals

bluesingingcat · Mar 10, 2004

Is there a way to sort a subtotaled spreadsheet by the
subtotals so that all the underlying transactions stay
with the subtotal?

Robert Nguyen · Mar 10, 2004

You can shrink it to level 2 then sort the whole thing by
your subtotal column.

Guest · Mar 10, 2004

Thank you. So simple.

-----Original Message-----
You can shrink it to level 2 then sort the whole thing by
your subtotal column.

.

Barbara · Mar 19, 2004

I can't seem to get this to work. I made sure that format
for the column is numeric but can't think of anything else
to do.

Debra Dalgleish · Mar 20, 2004

This will only work if you have one subtotal in the table. If you have
multiple subtotals, you can't sort them.