Sorting in a group header

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

Guest

I have Top/Bottom producer report where I group by the field Top/Bottom
producers... If the value in the 'DailyPL' field is positive or 0
'Top/Botton' field is populated with "gainers" value and if I have a negative
value it is populated with "loosers" value.
On the report I have breakdown on grouping by "Gainers" and "Loosers". But I
have a probelm of sorting within this groups. I need to sort data in Gainers
-DESC- and display it on the report from top number in DailyPL to 0, but I
need to sort -ASCE -for "Loosers" and display it from the highest negative
number.
 
Marina said:
I have Top/Bottom producer report where I group by the field Top/Bottom
producers... If the value in the 'DailyPL' field is positive or 0
'Top/Botton' field is populated with "gainers" value and if I have a negative
value it is populated with "loosers" value.
On the report I have breakdown on grouping by "Gainers" and "Loosers". But I
have a probelm of sorting within this groups. I need to sort data in Gainers
-DESC- and display it on the report from top number in DailyPL to 0, but I
need to sort -ASCE -for "Loosers" and display it from the highest negative
number.
Click to expand...


I think that you want to group on the top/bottom and then
sort on the expression =Abs(DailyPL) using ascending
 
Marshall thank you very much for your help.

It worked.


I created another column in my reporting query which I populated with the
same value as my DailyPL but with ABS -ABS(DAILYPL)- and called it "SORT"
column and then within the TOP/Bottom Groupings I sorted on "Sort" field DESC.
 
Back
Top