Sort Pivot Table Rows in "Big Ticket" order (desc by Absolute Value)

[TheLastLion]

I want to sort a pivot table by row to show the "big ticket" figures at the top, ie. descending by absolute value of the Grand Total of the rows.
I don't want absolute values for the individual figures; I want it for the totals.

The default is by product. Not helpful if you're looking at dollar figures.

Sorting by Grand Total is a bit better, but I want to focus on C and D, yet they're on the opposite ends of the table.

I want them ordered this way:

This is a trivial example: I'm working with a data set of 180,000 rows, so a calculation within the dataset would take 5-10 minutes to recalculate.

Any ideas how this might be done?

Many thanks in advance.

-Mike.

 

[GlennUK]

What about PowerPivot? A DAX formula in a new column there for abs value will feed into the PivotTable, and you should be able to sort on that.