2 Replies Latest reply: Oct 1, 2009 7:51 PM by John Witherspoon RSS

    Use a Description as a dimension but aggregate by unique id

      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