Hi everyone!
I have this scenario, that I need to get the sequence of dates, but it is depending on the previous record. Say sample below:
| Item | Date | New Data |
| A | 10/2/2016 | 10/2/2016 |
| A | 8/8/2016 | 10/1/2016 |
| A | 3/5/2016 | 8/7/2016 |
| B | 1/19/2016 | 1/19/2016 |
Steps would be:
1. Sort the data by Item Ascending, and Date Descending
2. Create a new field named: New Data, the condition would be: If row item is not the same with previous/above item, then the New Data value should be the row Date, else Get the minus 1 of the previous/above Date. (see data in the table above) - this I don't have yet idea how to come-up New Date values.
Regards,
Bill
