4 Replies Latest reply on Mar 3, 2016 8:58 PM by radha.sheetal

    How to show Monthly Average based on previous values

    Wing Nguyen

      Hi,

       

      I am having some issues creating a calculated field for Monthly Average by month based on all of the previous My Grand Total values.I have tried different average calculations - Window and Running and cannot get any of them to show the correct result I am expecting. Can you take a look at my workbook and show me how I can accomplish this? I also want the Month of January to show up on the crosstab with the 0 data. Thank you so much!

       

      Wing

       

          

      My Grand TotalMonthly AverageCumulative along Table (Down)
      January00.000
      February42.004
      March32.337
      April94.0016
      May115.4027
      June75.6734
      July68.0040
      August227.7562
      September06.8962
      October66.8068
      November97.0077
      December66.9283