10 Replies Latest reply: Dec 10, 2012 9:51 AM by Jonathan Dienst RSS

    Diagram rename legend entries

      Hello everyone,

       

      today a new Problem came up to me.

      I'm using 2 tables:

       

      Typs:

      TyppID
      typAA.1
      typBA.2
      typBA.2
      typCB.1
      typDA.1
      typDB.2

       

      Locations:

      pIDLocation
      A.1someName
      A.2someOtherName
      B.1dream
      B.2inTheAir

       

      Further I have a Pie Diagram with dimension pID and formula COUNT(pID) from table Typs. By doing this I calculate the ratios of the locations correctly.

      My problem is that in the legend of the diagram the names of Typs.pID will be used and I need to display the corresponding names of Locations.Location. I tried searching for similar issues and ended with no success...

      So how do I replace A.1 with someName etc. in the legend of an diagram?

       

      Thanks for your hints in advance.