5 Replies Latest reply on Jun 3, 2016 1:05 PM by Ivan Young

    How to display dimensions against other dimensions with Multiple values but only when all values match

    Richard Kissel

      I have two Dimensions User and Project when placed into the worksheet as listed below I see for each user what projects they belong too.

      My problem is I only want to see the users if they belong to both Projects.

      With the data below I only want Bob and Susan to be displayed. I attached an excel spreadsheet with the data.

       

      I have tried sets, groups, Calculated fields, etc... and I cannot see how to only display the users with both Projects.

       

      Help would be appreciated...Thank You

      MyWorksheetSnapshot.JPG