Use a Description as a dimension but aggregate by unique id

[#1]

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

[prieper]

Easiest way might be to use a calculated dimension like
Name & ' (' & ID & ')'

Peter

[johnw]

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.