Forum Discussion
Make new table based on values in multiple colunms
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
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
Resident Rockstar
Hi hpandersen,
you can make these kind of representations without creating a new table:
Do they look like something you need?
Cheers,
Sturla- hpandersenFrequent Visitor
Yes, could be a solution.
But how??
- sturlaws
Resident Rockstar
Sample report 😃
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.