Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Apologies if this is very simple. I have a unique id column and a description column (company name) which may not be unique. I want to display the company names as a dimension on a chart but ensure that if 2 companies have the same name their measures e.g. turnover are not summed together and treated as 1 value, thus I want to aggregate using the unique identifier.
Many Thanks
Paul
Easiest way might be to use a calculated dimension like
Name & ' (' & ID & ')'
Peter
That's what I do, or more accurately, when names are not unique, I just add the ID to the name field. After all, if two companies have the same name, you still need to be able to distinguish between them in SOME way.