Issue with Aggr function in set analysis

[#1]

Hi,

Can anyone please help with this requirement in set analysis.

Condition - [LP Days Past Due] = {'>4'}, [LP Delinquent Amt] = {'>50'}

I want to have this condition in set analysis and show the max of LP past due days  using group by based on customer name

I wrote my expression as

({<[LP Days Past Due] = {'>4'}, [LP Delinquent Amt] = {'>50'}>}[LP Days Past Due])

But I'm unable to put max and group by in same expression.

Thanks.

Sachin

[swuehl]

The max days would be

=max( ({<[LP Days Past Due] = {'>4'}, [LP Delinquent Amt] = {'>50'}>}[LP Days Past Due])

and the Amt

=FirstSortedValue({<[LP Days Past Due] = {'>4'}, [LP Delinquent Amt] = {'>50'}>} [LP Delinquent Amt], -[LP Days Past Due])

in a chart with dimension Customer.