This content has been marked as final. Show 3 replies
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.