Hope you are doing great. I have a requirement like :
I need to load the dashboard as to get sum of sales for last five days and the calendar should be selected in different color and also the data would be filtered for last five days.
Now, if somebody click on the calendar filter, it should show for that particular date. I am able to do it for that particular days but not for the other days(except last five days).
Any solution? I am attaching the workbook as well.