CODEWITHSUNDEEP
reporting-servicesreportdynamics-crm-2011
Santiago
Santiago

Reputation: 43

How to sort a report by a calculated field

I have a simple report made with FetchXml that shows something like this:

EMPLOYEE NAME             AUTH TOTAL           DRAFT TOTAL 
new_UserName                Exp1*                Exp2*

*Exp1: 

=FormatCurrency(Sum(Fields!lead1_new_totalauthorizedamountValue.Value))

*Exp2: 

=FormatCurrency(Sum(Fields!lead1_new_totalfeescollectedValue.Value)- Sum(Fields!lead1_web_totalrefundamountValue.Value))

Here is the issue: I can't realize how sort the whole table by Draft Total or by Auth Total.

Upvotes: 1

Views: 5132

Answers (1)

niktrs
niktrs

Reputation: 10066

For each group, go to properties, and in sorting enter the expressions you mention.

For the detail, go to properties and in sorting use the same expressions without the aggregation (SUM)

Upvotes: 2

Related Questions