Hi,
In the below table, Show field need to be calculated as expression or during scripting.
1) For category if there is a first initial date exists and there is no Actual date, status of that record need to be shown in Show Column.
2) If both initial date and actual date exist then status of next record to be shown in Show column.
3) If all status has initial and actual date then Show column should show 'Complete'
Category | Status | Initial | Actual | Show |
C1 | A | 16-01-2012 | | A |
C1 | B | | | |
C1 | C | | | |
| | | | |
C2 | A | 18-08-2011 | 18-08-2011 | B |
C2 | B | 05-12-2012 | | |
C2 | C | 11-07-2013 | | |
| | | | |
C3 | A | 16-12-2010 | 16-12-2010 | C |
C3 | B | 16-12-2010 | 16-12-2010 | |
C3 | C | 26-04-2012 | | |
| | | | |
C4 | A | 11-08-2011 | 11-08-2011 | Complete |
C4 | B | 01-06-2012 | 05-06-2012 | |
C4 | C | 26-07-2012 | 26-07-2012 | |
Please find the sample attached file.
Thanks,