3 Replies Latest reply: Jul 22, 2013 8:56 AM by Kaushik Solanki RSS

    Bar Chart for Daily Budget

    Bruce Tedder

      Hi All

       

      I have a FACT or TRANSACTION table in which my Dailys Sales and Monthly Budget is stored.

      I would like two bar charts (Sales vs Budget) but where the x-Axis dimension is daily. 

      Problem is my budget date is only 1st of each month as we set it monthly not daily hence I can Full Accumulate Sales but the budget only appears once.

       

      I would like to calc an ave daily budget, i.e.: BudgetValue/WorkDays and then Full Accumulate this?  Any ideas please? See attached current Chart.