Display Latest Cycle

[Varun1]

Hi,

My data :

Case Identifier	Cycle	Stage	Max stages in the cycle	Overall Status	Time (Days and Hours)	SLA Time Scale	SLA.Time
{E075B973-0000-C511-B2FA-0428B188370D}	6	2	5	Pending	0 00:20:21	Less Than 7 Days	12/05/2021 10:06:20 AM
{E075B973-0000-C511-B2FA-0428B188370D}	6	1	5	Pending	0	Less Than 7 Days	12/05/2021 10:05:59 AM
{E075B973-0000-C511-B2FA-0428B188370D}	5	2	2	Complete	0 00:15:18	Less Than 7 Days	21/10/2020 10:21:15 AM
{E075B973-0000-C511-B2FA-0428B188370D}	5	1	2	Pending	0	Less Than 7 Days	21/10/2020 10:05:57 AM
{E075B973-0000-C511-B2FA-0428B188370D}	4	2	2	Complete	0 00:07:21	Less Than 7 Days	20/10/2020 2:58:41 PM
{E075B973-0000-C511-B2FA-0428B188370D}	4	1	2	Pending	0	Less Than 7 Days	20/10/2020 2:51:20 PM
{E075B973-0000-C511-B2FA-0428B188370D}	3	2	2	Complete	0 03:22:03	Less Than 7 Days	20/10/2020 2:37:09 PM
{E075B973-0000-C511-B2FA-0428B188370D}	3	1	2	Pending	0	Less Than 7 Days	20/10/2020 11:15:06 AM
{E075B973-0000-C511-B2FA-0428B188370D}	2	2	2	Complete	0 00:46:35	Less Than 7 Days	05/08/2020 11:28:05 AM
{E075B973-0000-C511-B2FA-0428B188370D}	2	1	2	Pending	0	Less Than 7 Days	05/08/2020 10:41:30 AM
{E075B973-0000-C511-B2FA-0428B188370D}	1	2	2	Complete	0 04:24:59	Less Than 7 Days	04/08/2020 10:38:39 PM
{E075B973-0000-C511-B2FA-0428B188370D}	1	1	2	Pending	0	Less Than 7 Days	04/08/2020 6:13:40 PM
{1234B}	2	2	3	Pending	0 00:46:35	Less Than 7 Days	05/08/2020 11:28:05 AM
{1234B}	2	1	2	Pending	0	Less Than 7 Days	05/08/2020 10:41:30 AM
{1234B}	1	2	2	Complete	0 04:24:59	Less Than 7 Days	04/08/2020 10:38:39 PM
{1234B}	1	1	2	Pending	0	Less Than 7 Days	04/08/2020 6:13:40 PM

What I require now is show only the pending status of the latest cycle in of 'Case ID'. The output required is as shown below:As you can see in the above data when the 'Stage'  = 'Max stage in cycle 'the 'Status' is complete.

Case Identifier	Cycle	Stage	Max stages in the cycle	Overall Status	Time (Days and Hours)	SLA Time Scale	SLA.Time
{E075B973-0000-C511-B2FA-0428B188370D}	6	2	5	Pending	0 00:20:21	Less Than 7 Days	12/05/2021 10:06:20 AM
{E075B973-0000-C511-B2FA-0428B188370D}	6	1	5	Pending	0	Less Than 7 Days	12/05/2021 10:05:59 AM
{E075B973-0000-C511-B2FA-0428B188370D}	5	2	2	Complete	0 00:15:18	Less Than 7 Days	21/10/2020 10:21:15 AM
{E075B973-0000-C511-B2FA-0428B188370D}	4	2	2	Complete	0 00:07:21	Less Than 7 Days	20/10/2020 2:58:41 PM
{E075B973-0000-C511-B2FA-0428B188370D}	3	2	2	Complete	0 03:22:03	Less Than 7 Days	20/10/2020 2:37:09 PM
{E075B973-0000-C511-B2FA-0428B188370D}	2	2	2	Complete	0 00:46:35	Less Than 7 Days	05/08/2020 11:28:05 AM
{E075B973-0000-C511-B2FA-0428B188370D}	1	2	2	Complete	0 04:24:59	Less Than 7 Days	04/08/2020 10:38:39 PM
{1234B}	2	2	3	Pending	0 00:46:35	Less Than 7 Days	05/08/2020 11:28:05 AM
{1234B}	2	1	2	Pending	0	Less Than 7 Days	05/08/2020 10:41:30 AM
{1234B}	1	2	2	Complete	0 04:24:59	Less Than 7 Days	04/08/2020 10:38:39 PM

Please advice how this can be achieved,

Thanks in advance