Seperate Sorts on Same Page

[ARNOLD_ROSENBAUM_(Guest)]

I have a report that has sales results on both a monthly and year to date level.____I would like half the page to sort on sales on a monthly level with salesperson and sales and the other half to sort on a year to date level with salesperson and sales.____Is there any way to do this.

[kfleming]

Easiest way is to create two reports.____Kathleen__R&R Support

[Arnold_M._Rosenbaum__(Guest)]

But how do i get them on the same page???

[kfleming]

Two reports would be 2 pages (but would be easy.)____If you need the same page sort by month then salesperson and do group totals by salesperson.____Then in the summary area of the report, create a conditional grand total for each salesperson so that the total will only sum for a specific salesperson.__You would need to create as many totals as you have salespeople and each time you add a new saleperson, you would need to manually create a new total.__ __Kathleen__R&R Support