1 Reply Latest reply on Oct 2, 2012 2:25 AM by Darren Evans

    Calculation of Average Sales for year against average sales for a day

    Tony Course

      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.