10 Replies Latest reply on Jul 23, 2018 11:45 AM by Tony Smith

    Variance - compare the current five weeks data with the previous year's five weeks

    Tony Smith

      Hi All,

       

      Can someone please help me with the query below.

      I want to show the current five weeks sales and the same five weeks for the previous year based on the 'BBCA weeks in fin year' field.

      I want to compare the current five weeks data with the previous year's five weeks transaction sales.

       

      Also, compare the current five weeks of the budget to the previous year transactions sales

      I have attached a spreadsheet to illustrate what I am trying to achieve.

       

      I used the Report Date field to recognise the current BBCA week in fin year.

      For example today is 21st July 2018, so the current BBCA week in fin year is 1920 because we now have a completed week according to the BBCA week in fin year date.

      I have attached twbx package that shows the details of the BBCA week in fin year date.

       

      Thanks

       

      Regards

      Tony