Page 1 of 1

Help using Totals.Rank

Posted: Thu Dec 15, 2016 6:11 am
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!

Re: Help using Totals.Rank

Posted: Thu Dec 15, 2016 9:58 pm
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.

Re: Help using Totals.Rank

Posted: Fri Dec 16, 2016 4:41 am
by cmcfusion
Perfect! Exactly what I needed.
Thank you!

Re: Help using Totals.Rank

Posted: Fri Dec 16, 2016 7:45 am
by Alex K.
Hello

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

Thank you.