I am trying to create a dashboard which compares actuals sales VS budget also combined with slicers so people can make their own selections.
I have two tabs, one for the actual invoices to date which will be updated every day, and the other one for budget which is set at the start of the year.
The pivot table and the slicers from "Invoices" tab and then I use the formulas to calculate the Budget and the %Achieved.
However, the issue I have come across is that to date I have no invoices to Sainsburys or West Region or certain towns but I still want them to appear in the slicers and the dashboard so I could see the full view of the budget set for the month.
I would be very grateful if you could help me to find a solution to overcome this problem please.
I have attached my sample data.