I have some sales data, and I want to calculate the average sales for a day of the week (over a month) and over a year.
For instance average sales Monday for July and Compare the average sales on Monday over a year.
I have created multiple data connections to the same sales data.
In two separate worksheets I can calculate the average sales on Monday, for July and the average sales on Monday for the whole year
As soon as I try to combine the data into a single worksheet - the date for my calculations are either monthly or yearly, when I need separate calculations for month/year.