Max of a Count Distinct

[#1]

In my data we have transactions by customer Id.

I can do a count(Distinct custid) to find out how many unique customers i had over a period.

I can do count(distinct transId) to find out how many transactions i had over a period

What i would like to do now if to find what was the highest transaction count for the selected period by customer.

I don't need the customer itself, just the highest value.

Kind Regards

[#2]

Max

Seems to do it ....

(Aggr(Count(Distinct [Trans Id]), [MailCount]))

[Anonymous]

Harry,
From your description, it should be aggregated by customer:
max(aggr(count(distinct transid),custid))