Help using Totals.Rank

Stimulsoft Reports.WEB discussion
Post Reply
cmcfusion
Posts: 6
Joined: Wed Jul 20, 2016 9:24 pm

Help using Totals.Rank

Post by cmcfusion »

Can you help me use the Totals.Rank function? I have this syntax {Totals.Rank(Data, Details.Exp_ytd_units__funded_)}
my data band (Data) is ordered by the field I'm ranking (Details.Exp_ytd_units_funded_) in desc.

I need to reverse the order of the ranking. Here is an example of what I currently get
YTD.............. Rank
$100,000............. 5
$75,000...............4
$50,000 ..............3
$25,000 ..............2
$5,000 ...............1

And I need the results look like this
YTD Rank
$100,000...............1
$75,000...............2
$50,000...............3
$25,000............... 4
$5,000................ 5

Thank you!
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Help using Totals.Rank

Post by Alex K. »

Hello,

Please try to use the following expression:

Code: Select all

{Totals.Rank(DataSourceName,DataSourceName.ColumnName,false,Stimulsoft.Report.StiRankOrder.Desc)}
Thank you.
cmcfusion
Posts: 6
Joined: Wed Jul 20, 2016 9:24 pm

Re: Help using Totals.Rank

Post by cmcfusion »

Perfect! Exactly what I needed.
Thank you!
Alex K.
Posts: 6488
Joined: Thu Jul 29, 2010 2:37 am

Re: Help using Totals.Rank

Post by Alex K. »

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.
Post Reply