2 Replies Latest reply: Aug 19, 2009 10:07 PM by Héctor Muñoz RSS

    Pivot Table i need an average of a row

    patdanderson

      I currently have a pivot table built in my document.

      The dimensions are

      Customer, Origin, Destination, PickupWeek

      Expression= Sum(TripCounter) <----This is just a "1" added on to each record to save me from doing a count.

      I want to get an average of the rows in my table (See Attached):

       

      PickupWeek
      CustomerOriginDestination8/1/20098/2/20098/9/20098/16/20098/23/20098/30/20099/6/20099/13/20099/20/20099/27/200910 wk Average
      123ABCXYZ556841012171058.2
      456ABCXYZ568543104595.9


       

      Please help. I really need this to work like this so i can replace some reports i currently send out in excel.