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...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper 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

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    5 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Can u send me ur mail id , i will send the pbix file. Unable to send it here as I dont have the option here

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        5 years ago

        click the table icon then specify the table size and fill it with your sampe data.