6 Replies Latest reply on Feb 23, 2012 8:19 AM by John L

    KPI based on performance for one period compared to a previous period?

    John L

      I am comfortable creating KPI's based on a specific value ie If Sales are greater than $1000 then "Good" else "Bad"

       

      How would you go about creating a KPI where if Sales in Feb are higher than Sales in Jan then it's "Good" else "Bad"

       

      Jan and Feb are date dimensions and Sales is a measure. Dates are showing as columns in my table and Sales (and other measures) are rows. Would like to have a tick if the latest month is higher than the previous month and a cross if not.

       

      Help much appreciated.