Hi all. I have a little issue at the moment. I'm stuck on a report. It has a grouping on Collector for an account. Then shows how much they collected and who was the salesperson for a file.
Example (sp is salesperson. It is sorted by salesperson name)
Collector: John
SP Total
A 100
B 200
C 500
D 100
----------
total: 900
Now what I am trying to do in the same report is to have another 2 columns again salesperson and total but this time it is sorted by total instead. In essence it is the exact same data shown sorted first by salesperson and the second time it is sorted by total. 4 columns instead of 2. Can't figure this out. Help!!!!
Example (sp is salesperson. It is sorted by salesperson name)
Collector: John
SP Total
A 100
B 200
C 500
D 100
----------
total: 900
Now what I am trying to do in the same report is to have another 2 columns again salesperson and total but this time it is sorted by total instead. In essence it is the exact same data shown sorted first by salesperson and the second time it is sorted by total. 4 columns instead of 2. Can't figure this out. Help!!!!
