1 Reply Latest reply on Aug 30, 2013 5:47 AM by Matt Lutton

    (Another) Conditional Formatting Problem - When your measures for actual and target are within the same column...

    gall3on

      I've reviewed countless implementations of conditional formatting from J Mako and J Drummey but either I'm just not doing my implementations correctly or none of their solutions apply.

       

      Here's the problem:

      • our BI created a source for measures which is structured like so (table 1):

       

      Date
      SubmitsActual/ProjectedVisits
      201212345Actual250000
      201317890Actual267890
      201216789Projected245678
      201319870Projected278901

       

       

      I'm trying to create a 'dashboard' view structured as below:

      2012 (filterered)ActualProjectedVariance
      Visits250000245678-17%
      Submits123451678926%

       

      I managed to create the said table above, but the challenge is applying the conditional formatting under Variance.  With my data structured as is on Table 1 by BI (this is non-negotiable formatting on the source), how can I apply the J Mako/J Drummey techniques to compare my Actual/Projected measures using conditional formatting?