Set Analysis query

[rahulsingh12]

Hi,

I have 2 fields SalesID,CSRID

SalesID will have all the CSRID  as well as some unique SalesID.

when I make a selection in SalesId the corresponding values in CSRID  are selected.

Is there a way to write an expression such that no matter what SalesID I Choose it will work only on values of csr and ims iD.

count({$<SalesID=,>}{$<CSRid=p(SalesID)>} if(CSRid=SalesID,  'some value'))

So here what I want is if in the current selection in csrid is in salesId the if that is equal to salesid then count some value.

Even if I select SalesID first then the corresponding CSRID it should neglect the current selected SalesID value.

Regards,

[vishsaggi]

Try this?

=  Sum(Aggr(Count({$< CSRid = p(SalesID), SalesID= >} if(CSRid = SalesID, 1)), CSRid))

[rahulsingh12]

No,

It is not doing the sum.

Regards,

[vishsaggi]

Try this?

=  Count({$< CSRid = p(SalesID), SalesID= >} if(CSRid = SalesID, 1))

If not can you share your expected output with a sample file here?