Pivot Table that groups by day of week.

**travkliewer** · 09-09-2007, 11:43 PM

I have a bunch of sales figures and I want to see how each day measures up compared to the others. For example, I want the average sales for Monday, the average sales for Tuesday, etc. A pivot table would be the perfect idea, i can group it by days, weeks, months, etc. but I can't group it by day of the week. I could use database functions, but I would have to include another column in the data range that calculates the day of the week and go from there. I guess that would be OK, but I was looking for a simpler route. Let me know if anyone has any ideas. Thanks.

**dominicb** · 09-10-2007, 05:23 AM

Good morning travkliewer

You can't group by day from within the pivot table options, but why not include the day of the week in the source data? You can then include this column in your pivot table and view any information you like by day. Say your date is in column A, then something like this formula would give you the day :

=TEXT(A1,"dddd")

HTH

DominicB