Sorting one way for one group and another way for another group

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello.

I am working on a report that lists stocks we are watching. We have two
types of positions we are looking at - Long and Short. For each stock we have
a target price and a calculation to show whether the current price is above
or below that target (call it premium and discount for above and below
respectively).

I have set-up the report to group on Long or Short without problems. What
I'd like to know is if there is a way that I can have the report sort
descending for Short but sort ascending for Long. Is this possible?

Thanks!
CKD
 
I'm not real sure about your request but assuming you have gender and salary
fields in your report. You want to sort Females by Descending salary and
Males by Ascending salary. You could try use an expression like:

=IIf([Gender]="F",-[Salary], [Salary]) Ascending
 
Back
Top