Skip to Content
Former Member
May 04, 2013 at 07:55 AM

Crosstab - sorting by formula not used in the report


Hi All,

I've build a P&L report in CR9 where income values are positive and cost values are negative. Fields are sorted by summary field in descending order putting highest income positions at the top and highest cost position at the bottom of the report. How can I sort the report so that it shows highest cost positions just below smallest income positions? I've created formula field as abs(summary field) but, as it is not used in the crosstab, I cannot use it as sorting order.