7 Replies Latest reply on Nov 12, 2017 8:27 PM by Zhouyi Zhang

    Averages

    Gavin Wong

      Hi community,

       

      this maybe a very simple operation but the level of average is quite confusing for me

      Attached is the workbook of the sample superstore, filtered in view is 4 years of data showing $2.2 mil

      i would like to show the average, over the 4 year as 1 single value which is $574k, however when i click on measure, then Average, it is showing $230. how is that $230 being calculated ? i need it to show as $574K

       

      same as if i were to filter to show monthly data in 2016, then the average should be divide by 12, and show 1 single value. However i am not seeing it.

      what am i doing wrong ?