1 Reply Latest reply on Jul 19, 2018 5:28 PM by Ken Flerlage

    Split and calculate year and monthly information

    nataraj.vijayanagaram

      Hello All,

       

      I have need to create a report similar to the below example. Can you please explain how this can be achieved?

       

      Calculation: Sample store data as reference however added an year to the order date..

       

      Quantity = Number of Items Sold

      Sales = Total Sale Amount

      Discount = % Discount

      Actual Discount is derived by percentage and Sales amount

       

       

      FY 2017Jan 2018Feb 2018Mar 2018Apr 2018FY 2018
      Quantity820597363885733645
      Sales50,76743,97120,30158,87236,52239,917
      Discount16%16%18%13%19%17%
      Actual Discount8,1237,0923,6947,7037,1016,671

       

      For the above table. All the FY columns need to have the total for the year divided by number of months (Average). where as for the current year, I need to split and show the actuals.

      I can separately calculate the columns and add them to the view however the challenge is that every time the month changes -- next month needs to be added automatically for the current year data.

      Example - when I move to June date, May column should be added automatically next to Apr.

       

      Looking for some suggestions from the experts. Please advise.

       

      Thank you!