I have some sales data which contains two dates(actually multiple dates). and i would love to use the calendar for both dates.
I'm guessing i'm setting up my Master Calendar wrong.
I have attached an limited example. where both dates and the sales amount are shown. but since the invoice date and the order aren't always the same. I would love to have the pivot like it's shown. sales in all the monts, and the order intake in the same month.