SUBTOTAL Sort
 

How can you sort by Subtotal values but keep associated data together?

For instance, I sort data by part number. Then I subtotal the dollar values
(+/-)associated with each part number.

I then want to rank (i.e. sort) by the highest net dollar difference to the
lowest net dollar value based on the net SUBTOTAL values.

SUBTOTAL Sort
 

Try hiding the details--but keep the subtotal rows visible.

Then sort your data.

(I was pretty amazed when I saw this work--it was an accident!)

nuggie wrote:

How can you sort by Subtotal values but keep associated data together?

For instance, I sort data by part number. Then I subtotal the dollar values
(+/-)associated with each part number.

I then want to rank (i.e. sort) by the highest net dollar difference to the
lowest net dollar value based on the net SUBTOTAL values.

--

Dave Peterson