Set Analysis Help...

[samvile18]

Hi all,

I have the following set analysis which returns the attached table:

Count(Distinct{<IsAnnualReview={'N'}>}JourneyId)

Test table

I need to add a line to the expression so it only shows the max JourneySequence. I assumed it was a mixture off Aggr(Max but I cannot seem to get it to work properly. 

Any help would be greatly appreciated. 

Thanks in advance.

[Marcel_Garcia]

Try this:
Max(Aggr(Count(Distinct{<IsAnnualReview={'N'}>}JourneyId)))

[samvile18]

Sadly, it didn't like that at all...error on the expression with aggr needing 2 or more parameters.

[samvile18]

**BUMP**