0 Replies Latest reply on Aug 30, 2018 5:55 AM by shay shushan

    Calculation growth of income

    shay shushan

      I try to show On Dashboard an increase in revenue by comparing two different periods.

      In other words, the comparison can be between random dates rather than specific months or weeks between different years.

       

      for example:

      first period: 18/01/2017 - 3/02/2017

      second period: 16/04/2018 - 30/4/2018


      The comparison can also be between two periods in the same year.

      for example:

      first period: 18/01/2017 - 3/02/2017

      second period: 16/04/2017- 30/4/2017

       

      When I tried to calculate the revenue growth,

      the filter was unable to separate the revenues of the first and second periods.

       

      I attach a file in which I prepared the Dashboard but I was unable to calculate the revenue growth.

      Also includes an Excel DB file.

       

      Thank you very much for your help!

       

      Note - To separate the two periods, I used to join the table with itself so that each year would have its own variables.
      I guess it is redundant but it was out of an attempt to separate the summary of the revenue each year.