Forum Discussion
Intracolumn data
I have 3 columns as below. I need to find a way to create a new table which tells me the difference between the first value according to date and last value, for each unit. I am not to familiar yet with the manage relationships function, but have been attempting multiple ways to solve this with no success. Any help is appreciated!
| Unit Name | Percentage | Date |
| west | 6.20% | 2/9/2016 |
| west | 6.50% | 2/21/2017 |
| west | 7.00% | 2/9/2018 |
| east | 5.10% | 7/25/2018 |
| north | 6.00% | 5/8/2018 |
| north | 7.00% | 10/13/2016 |
Desired Table
| unit name | Difference |
| west | 0.8 |
| east | 0 |
| north | -1 |
Hi,
Please find the solution in the attached file and tell me what you thought.
Hi,
Please find the solution in the attached file and tell me what you thought.
Thank you so much, this helps a lot!
