7 Replies Latest reply on May 21, 2013 8:25 AM by Jonathan Drummey

    Measure Activity from Two Dimension Names in one Statement?

    colby.pash

      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.