Skip to Content
0
Former Member
Dec 07, 2008 at 10:06 PM

How to sort groups based on calculated field?

235 Views

Hi all,

I have a quesion. I have a report with 3 groups. Here's how it looks like when it first run (Group1 level):

M1 M2 M3 M4 ... M13 CY PY Diff Diff%

2 5 5 8 5 25 20 5 20%

4 5 6 5 5 25 30 -5 -20%

1 2 15%

I need to sort these groups by Diff%. When I go to Report - > Group Sort Expert and select "All" based on... it gives me some other formulas in drill down but not that one that I need. How to add formula I need to that drop down list that CR offers you to sort group based on?

I'm using CR XI R2.

Thanks