2 Replies Latest reply: Nov 23, 2012 7:12 AM by lizard191 RSS

    Comparing Results of Dimension

      Hello,

       

      I have a requirement to have the following chart in a document:

       

      Timescale
      TargetLast WeekThis WeekVariance
      Sales152010-10





       

      Target, Last Week, This Week, Variance are values of the Dimension Timescale, Sales is an expression to return the values.

       

      This tricky bit is the formatting that is required, I need cells highlighted comparing the results to the target, I'm unsure on how to write the code for a dimension to compare say Last Week to This Week

       

      Any ideas/suggestions?

       

      Regards

       

      Chris