6 Replies Latest reply on Sep 17, 2012 7:47 AM by Russell Christopher

    Calculate average of sum

    Xiaodong Han

      I have a deailed level data table.  Say store sales by day (Fields: Region, store, date, sales).  I need to get store monthly total, whcih I can use sum.  However, I need region average store sales:

       

      Region     Month 1 Month 2 ...

      A               100          140

      B               120          150

      C               110          90

       

      How should I do his?