I'm trying to measure both incoming and outgoing activity. I have two Dimensions ([OutgoingName] and [IncomingName]) and need to bring all activity together.
I've gotten the desired results with the IF statement below, but I'd rather not replicate the below calculation 200+ times when I know there's got to be an easier way... I'm having trouble realizing the right path.
IF [OutgoingName]="Matt" THEN [OutgoingName] ELSEIF [IncomingName]="Matt" THEN [IncomingName] END
My issue at its is due to data structure, but there's not much I can do about that. Any help would be great.
