Set Analysis Aggr Function

[stjernvd]

I need to apply set analysis to this function, so that no other selection for Source or Destination1 will change the table.

=Aggr(Count(DISTINCT(Source)),Destination1)

How do I do that?

[swuehl · Accepted solution]

Try

=Aggr(Count({<Source=, Destination1= >} DISTINCT(Source)),Destination1)

[sunny_talwar]

Or this:

=Only({<Source, Destination>}Aggr(Count(DISTINCT{<Source, Destination>} Source),Destination1)

[raman_rastogi]

=Aggr(Count({<Source=, Destination1=,Date=,X= >} DISTINCT(Source)),Destination1)

Put Fields =, in your set analysis