Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Group a number in 2 groups

Hi all,

 

I have list of numbers which i have grouped with the function "New Group" like below:

 

Group 1:

500

600

700

 

Now as you can see I have already grouped the number 500 in group 1. But i want to group the number 500 also in group 2 like below:

 

Group 2:

800

500

 

 

Can you guys help me out with this?

 

Thanks in advance,

Özgür

 

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I think that you might have to explain this better in order to get some solution.

     

    Best regards,

    Kristjan76

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Özgür,

     

    I'm afraid the "New Group" function doesn't have such a feature. I would suggest you create a new table like below and establish a relationship. 

    Groups     Relationship Column

    Group 1 500
    Group 1 600
    Group 1 700
    Group 2 500
    Group 2 800

    Group-a-number-in-2-groups

     

    Best Regards,
    Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous,

     

    Could you please mark the proper answers as solutions?

     

    Best Regards,

    Dale