16 Replies Latest reply: Dec 13, 2013 9:28 AM by Charlotte Gilbert RSS

    Referencing another row in a table

    Charlotte Gilbert

      Please can anyone help, we currently have a straight table with the 'Ward' as the dimension, and results and RAG ratings as the expressions.

       

      For some results, the wards have joint data, but we don't want to duplicate the data at the source, we just want to base the RAG rating of one ward on another ward.

       

      For example, here is a very simple representation of what we have now. At the moment Ward1b is showing red as there is no data, but we want it to show green, as Ward1a is green.

       

      WardResultRAG rating
      Ward1a90%Green
      Ward1b-Red

       

       

      And this is what we want to get to:

       

      WardResultRAG rating
      Ward1a90%Green
      Ward1bJoint WardGreen

       

      Any help would be much appreciated