5 Replies Latest reply on Jul 24, 2018 12:17 AM by Shinichiro Murakami

    compare current week data with the previous year's week

    Tony Smith

      Hi All,

       

      Can someone please help me with the query below.

       

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

       

      I want to compare the current week data with the previous year's week transaction sales. I.e (1920 / 1820 -1)

       

      Also, I want to do the same calculation for Budget data. I want to calculate the budget data in the current week in fin year with the transaction sales data from last year i.e 1920 budget data / 1820 - 1 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 23rd 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