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.