Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Show only common values from groups

Hi Everyone,

 

     I  need to show only the common vales in groups. PFB image for the same.

  Here For the S.No 1 , I have 2 groups, one is GL_JRNL & Other is GL_POST, There are 2 users are common between these 2 groups. So i need to create a measure/column to show only the common vales which are highlighted in the screenshot.

   Thanks in Advance.

8 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    What have you tried?  Seems like a combination of INTERSECT and CONCATENATEX should do the trick.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I am not getting how to write the expression!

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Can someone help on this please!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      lbendlin  Could you please show me how its done. I have no idea how its done.

      • lbendlin's avatar
        lbendlin
        Super User
        5 years ago

        Please provide sample data in usable format (not as a picture) .