Sorting on a formula column

[jraheja]

I am using CR 10. One of my column is a formula calculation and the user wants data sorting on that column. Any roundabout way to achieve this??


My formula is (Sum ({@YearEntered_YTD_ Sales}, {@Merge Club})/{Sheet1_.2004 Membership}) * 100 at a group header level.

 

[Turkbear]

Hi,
One way would be to create a group using the formula, but it would have to come after the Sum is calculated.







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[jraheja]

How would that help??

My report displays as
50,000 (Group 1)
Club a (Group 2) - sales, Sales per 100 m (formula above)etc
Club b (Group 2) - sales, Sales per 100 m (formula above)etc

100000 Group level 1)
Club c - sales, Sales per 100 m (formula above)etc
Club d - sales, Sales per 100 m (formula above)etc

Each club can be a merge of more than one club and so is again a formula. This Group 2 is a header since we have all summations.

Can I just call a stored procedure at the formula location?