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

    Pivot Table i need an average of a row


      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):


      CustomerOriginDestination8/1/20098/2/20098/9/20098/16/20098/23/20098/30/20099/6/20099/13/20099/20/20099/27/200910 wk Average


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