How to do set analysis in this Aggr Sum expression

[#1]

Hi Guys,

I am using following Expression in text box to show sum of total paid amount for orders.

=sum(Aggr([Paid Amount], OrderId,[Paid Amount]))

Where Can I add 'if' statement or set analysis in this expression to only see total amount where [Sales Rep] = 'James' ?

[stephenedberkg]

try like this

aggr( sum({< [Sales Rep] = {'James'}  >}[Paid Amount])OrderId)

[#3]

Thanks Stephen, but did not work

[NareshGuntur]

I don't think you need to use Aggr function for that.

The below should do -

sum({< [Sales Rep] = {'James'}  >}[Paid Amount])

[tamilarasu · Accepted solution]

May be this.

=sum(Aggr(If([Sales Rep] = 'James',[Paid Amount]), OrderId,[Paid Amount]))

Or

=sum(Aggr(Sum({<[Sales Rep] = {'James'}>}[Paid Amount]), OrderId,[Paid Amount]))

[sunny_talwar]

Not sure how and where you using this, but may be this (if what Naresh provided doesn't work for you)

=Sum({<[Sales Rep] = {'James'}>}Aggr(Only({<[Sales Rep] = {'James'}>}[Paid Amount]), OrderId,[Paid Amount]))

[#7]

Thanks for your replies guys..

Almost everyone's expression worked.. but I picked Tamil's for now

Thanks