This content has been marked as final. Show 2 replies
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):
|Customer||Origin||Destination||8/1/2009||8/2/2009||8/9/2009||8/16/2009||8/23/2009||8/30/2009||9/6/2009||9/13/2009||9/20/2009||9/27/2009||10 wk Average|
Please help. I really need this to work like this so i can replace some reports i currently send out in excel.