Page 1 of 1

Seperate Sorts on Same Page

Posted: Sat May 12, 2001 11:42 am
by 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.

=> RE: Seperate Sorts on Same Page

Posted: Tue May 15, 2001 5:01 am
by kfleming
Easiest way is to create two reports.____Kathleen__R&R Support

==> RE: Seperate Sorts on Same Page

Posted: Fri May 18, 2001 12:14 pm
by Arnold_M._Rosenbaum__(Guest)
But how do i get them on the same page???

===> RE: Seperate Sorts on Same Page

Posted: Fri May 18, 2001 3:11 pm
by 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