how to get max of particular category based on category not by value

[NavaneethArra]

Runtype

BOP

Assumption 1

Assumption 2

Assumption 3

Roll forward EOP

Population update EOP

output to be as below based on dynamic selection

Runtype

BOP

Assumption 3

Roll forward EOP

Population update EOP

I have 4 Quarters slicers selection, based on the slicer selection the assumptions gets added or removed ... i wanted to show the latest assimption along with the remaining BOP,roll forward EOP and Population 

[NavaneethArra]

Hi 

Basically we get the quarterly data for these Run types , however all the Runtypes would be same but the assumptions gets added ,,,, and we need to show the latest assumption everytime whenever we select the slicer based on quarter 

For ex : 

We have Q3 2023 

where in we have 

BOP 
Assumption 1
Assumption 2
Population EOP 
Roll forward EOP

In this case i when i select Q3 2023 i should show the MAX of assumption which is Assumption 2 along with 
remaning run typres 

Like 

BOP
Assumptions2
Roll forward EOP 
Population update EOP

Runtype

BOP

Assumption 1

Assumption 2

Assumption 3

Roll forward EOP

Population update EOP

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?