Issue with Aggr function in set analysis

Fri, 19 Jun 2015 17:23:51 GMT

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

Re: Issue with Aggr function in set analysis

swuehl — Fri, 19 Jun 2015 17:29:38 GMT

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.