Hi
I'm trying to get an average value of a pivot table and getting nowhere, the data is for a years value split up by dept. and for each day of the week. The pivot is like this:
I am trying to get an average value per day, so setting the value to average in Excel pivot gives me a value of 1, so I think it is that I need to divide the day value by the amount of Mon/Tue etc. days in the year if that sounds right. I have no idea how to go about this in a pivot, can anyone enlighten me how to set the values within the pivot so they are averages per day, and also by dept if possible, what do I need to do to the data set, what column of values do I need to calculated and do I need to use a calculated field/item?Please Login or Register to view this content.
Thanks
Lee!
Bookmarks