Yes, it is possible in Amazon QuickSight,

You'll need to create a calculated field that:

1. Filters records within your date range

2. Finds the maximum date within that filtered set

3. Returns the corresponding string value for that maximum date

4. Groups by pID and cID

Example with Your Data :

Given your table with:

• pID: 5055, cID: 41

• mindate: 9/27/2025

• maxdate: 9/30/2025

The calculated field will:

1. Filter records where Date is between 9/27/2025 and 9/30/2025

2. Find the maximum date in that range (9/30/2025)

3. Return "StringB" for the row with date 9/30/2025

4. Return null for all other rows