Problem comparing actuals (in revenue per invoice for a month) vs budget ( 1 total per month)

[chellamotte]

Hi,

I am currently trying to make comparison KPI's to followup monthly actuals vs the monthly budget I calculated.

The actuals are one line per invoice (per customer), which I divided in months using a splicer.

But my problem lies in the budget, which is just an excel sheet with the month and the total for that specific month.

Every time I use the monthly budget, it keeps using the total value of the entire year, which isn't what I am looking for.

Any suggestions on what I would be doing wrong?

Thanks in advance!

[Dan80]

Are you using a date table which is linked to both the actuals and budget tables?