Make new table based on values in multiple colunms

[hpandersen]

Hi

I have a table that contains informations about agreements.

Agreement	Account	Originating agreement	Agreement type
0001	Account1		Type1
0002	Account2		Type2
0003	Account3		Type1
0004	Account1	0001	Type3
0005	Account1	0001	Type4
0006	Account1	0001	Type5
0007	Account2	0002	Type3
0008	Account4		Type1
0009	Account3	0003	Type4
0010	Account5		Type2
0011	Account6		Type2
0012	Account7		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
Agreement	Account		Agreement	Account	Agreement type
0001	Account1		0004	Account1	Type3
			0005	Account1	Type4
			0006	Account1	Type5

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

Any suggestions?

Regards Hans

[sturlaws · Accepted solution]

Hi @hpandersen,

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

Do they look like something you need?

Cheers,
Sturla

[hpandersen]

Yes, could be a solution.

But how??

[sturlaws]

Sample report  😃

Cheers,
Sturla

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