Hi,
I have a calculated dimension:
=aggr(firstsortedvalue({<ContactType={'Email'}>}ContactDetail,-ContactID),TR_ID)
This was working ok until the format of the ContactID and TR_ID fields changed from numeric (e.g. 95423) to text (e.g. ABC95423).
The dimension is used in a straight table chart and has changed from returning the email address field to being unable to return anything, just a - in the field.
Can anyone help?
Thanks, Catherine.