3 Replies Latest reply on Jul 31, 2015 1:49 PM by Rody Zakovich

    Return only common results in set

    Jonathan Legare

      Hi, I've been racking my brain, and searching the forums for this, and it seems like it's such a simple task, or maybe I'm just missing something.

       

      I have two dimensions memberId, then Booked/Failed. I want to show only the memberId's which return both results, Booked(errorTitle=Null) and Failed(errorTitle not null). Screen shot is below, results I want to keep are highlighted. I've tried creating a conditional set, and it does work, but it's a static option when I'm dealing with dynamic data. I can strip sensitive data and upload a workbook, but I'm really hoping this is something I'm severely overthinking.

       

      Capture.PNG