8 Replies Latest reply: Dec 14, 2011 6:05 AM by stijn.vanhees RSS

    Present actual vs budget

      Hi all,

       

      I have 5 factories, all have a score on 20 subjects. The maximum score on each of the 20 subjects is 5, but the "budgetted" score can be lower than 5. I have created a bar chart with dimension "subjects" and expression "Only([Score])" which gives me an overview of how things are for each factory. However, this bar chart does not include how far each factory is away from budget.

       

      Reference lines don't seem to work, because the budget is different for each subject, or am I wrong here?

       

      Thanks for you help!

       

      Kind regards,

      Stijn