Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try
=Aggr(Count({<Source=, Destination1= >} DISTINCT(Source)),Destination1)
Try
=Aggr(Count({<Source=, Destination1= >} DISTINCT(Source)),Destination1)
Or this:
=Only({<Source, Destination>}Aggr(Count(DISTINCT{<Source, Destination>} Source),Destination1)
=Aggr(Count({<Source=, Destination1=,Date=,X= >} DISTINCT(Source)),Destination1)
Put Fields =, in your set analysis