Forum Discussion

hpandersen's avatar
hpandersen
Frequent Visitor
6 years ago
Solved

Make new table based on values in multiple colunms

Hi

 

I have a table that contains informations about agreements.

AgreementAccountOriginating agreementAgreement type
0001Account1 Type1
0002Account2 Type2
0003Account3 Type1
0004Account10001Type3
0005Account10001Type4
0006Account10001Type5
0007Account20002Type3
0008Account4 Type1
0009Account30003Type4
0010Account5 Type2
0011Account6 Type2
0012Account7 Type2

 

Some of the agreements are Main agreements while some are Sub-agreements to the main agreement. Main agreements are the ones were field Originating agreement is empty. Agreements can also have different agrement types.

 

I can easily make a list of the main agreement, but I have difficulties with making a list that contains only agreements related to originating agreement, like this:

Main agreements Sub agreements  
AgreementAccount AgreementAccountAgreement type
0001Account1 0004Account1Type3
   0005Account1Type4
   0006Account1Type5

I guess I can make a new table, but I'm in doubt how I can filter this selection?

 

Any suggestions?

 

Regards Hans

  • Hi hpandersen,

     

    you can make these kind of representations without creating a new table:

    Do they look like something you need?

     

    Cheers,
    Sturla

     

3 Replies

  • sturlaws's avatar
    sturlaws
    Icon for Resident Rockstar rankResident Rockstar

    Hi hpandersen,

     

    you can make these kind of representations without creating a new table:

    Do they look like something you need?

     

    Cheers,
    Sturla

     

      • sturlaws's avatar
        sturlaws
        Icon for Resident Rockstar rankResident Rockstar

        Sample report  😃

         

         

        Cheers,
        Sturla

        If this post helps, then please consider Accepting it as the solution. Kudos are nice too.