5 Replies Latest reply on Oct 15, 2018 2:43 PM by Natalie Crow

    How do you compare 2 things of the same measure/dimension?

    Natalie Crow

      I have a list of people and places. There's multiple people assigned to multiple places so I created a calculation that would list all of the people at each location. Now I am trying to use parameters as filters to 1. select a person and all the places will appear - and still list the other people at that place 2. select 2 different people and it will show the places they have in common - and list any other people. Any ideas?

       

      Original Data Example:

        

      RowPlacePerson
      1TorontoJeff
      2TorontoBob
      3TorontoJames
      4MontrealFred

       

      What I have now Example:

       

       

      PlacePerson
      TorontoJeff, Bob, James
      MontrealFred

       

      What I want example - if have a filter/parameter for person 1 and a filter/parameter for person 2 and I choose Jeff and Bob then it would pull up the shared place (Toronto) and include an additional shared person (James) if there are any:

       

      PlacePerson
      TorontoAnd James

       

      Also attached a workbook if that helps - version 10.5.1!

       

      Thanks a bunch.