Please check the below table for each leasing agent:
<tbody>
</tbody>
I need to count 5 categories as the below:
1- Just Browsing
2- Interested
3- On the Fence
4- Hook Line & Sinker
5- Lead Lost
But I want to count the last date of the progress without deleting the date/s before.
For example, in Client 1 we need to count only (Hook Line & Sinker), and Client 2 we will count only (On the Fence), etc
The results I need to be as the below:
<tbody>
</tbody>
Please let me know if this it clear.
Client |
<tbody> </tbody> | Just Browsing | Interested | On the Fence | Hook Line & Sinker | Lead Lost | ||||
1 | Active |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
2 | Active |
<tbody> </tbody> |
<tbody> </tbody> | |||||||
3 | Active | 9-Apr-19 | 5-May-19 |
<tbody>
</tbody>
I need to count 5 categories as the below:
1- Just Browsing
2- Interested
3- On the Fence
4- Hook Line & Sinker
5- Lead Lost
But I want to count the last date of the progress without deleting the date/s before.
For example, in Client 1 we need to count only (Hook Line & Sinker), and Client 2 we will count only (On the Fence), etc
The results I need to be as the below:
Progress Update | Clients Status |
Just Browsing | 5 |
Interested | 6 |
On the Fence | 4 |
Hook Line & Sinker | 6 |
Lead Lost | 2 |
<tbody>
</tbody>
Please let me know if this it clear.
Last edited: