How to Remove These Nulls...

[samvile18]

I've got the following set analysis which returns this table, I want the table to return just the max Sequence for each ID...can someone point out where I'm going wrong please?

Max(Aggr(Count(Distinct

{<
JourneyStartDate_MonthStart = {"$(vFromDate)"},
ProcessEndDateNoBlanks_MonthEnd = {"< $(vToDate)"},
IsAnnualReview={'N'}
>}
JourneySequence), JourneyId))

What I'd want here is the ID, Status and Journey Sequence to be just relevant to the max of 8

For the above I'd want to see just the on Id, Business in Force and 8...I feel like I'm so close.

[rubenmarin]

Hi, maybe you only need: Max(TOTAL <JourneyId> JourneySequence)