Hi All, any help on this would be greatly appreciated.
The data below refers to a Used car stocklist advertising changes. Each line represents a log of a price change on the internet.
I need the following data retrieved from this list.
1 - Total number of internet changes for each car
2 - The Date of the last previous change
3 - The amount of the last previous change
4 - Total Price change variance
<tbody>
</tbody>
The data below refers to a Used car stocklist advertising changes. Each line represents a log of a price change on the internet.
I need the following data retrieved from this list.
1 - Total number of internet changes for each car
2 - The Date of the last previous change
3 - The amount of the last previous change
4 - Total Price change variance
Stock# | Value Before | Value After | Log Date | |||||||
1234 | 0 | 13,888 | 01/03/2019 | |||||||
1234 | 13,888 | 13,945 | 03/03/2019 | |||||||
1234 | 13,945 | 13,940 | 06/03/2019 | |||||||
1235 | 0 | 15,990 | 04/03/2019 | |||||||
1235 | 15,990 | 16,580 | 06/03/2019 | |||||||
1235 | 16,580 | 16,690 | 07/03/2019 |
<tbody>
</tbody>