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!