Put the Date field into the row area, and group by Days only.
Enter your start and end date in the Grouping dialog box.
For the number of days, you can enter the number of days in your range,
or a big number, if you aren't sure how many days are in the selected range.
Then, in the Date field dropdown, click Select All, to uncheck all, then
select the item with your date range.
Marc Fleury wrote:
I'm hoping someone can give some pointers to a pivot table newbie.
I have a bunch of data in three colums: Player, Score, and Date. I want a
pivot table that will show me the average Score for every Player, given an
arbitrary Date range that I want to be able to specify.
I'm partway there. I set up a pivot table, pull Player onto the Row Fields,
and I put Score into the Data area.
If I put Date into the Row Fields, and then group these by month, it almost
gives me what I want -- I can click on "Date" on the pivot table and I have
little boxes that I can check off if I just want to see the data for
November, or whatever. But if I want to see just the data for, say, Nov 20-
26, I'm out of luck. If I right-click on Date, choose Grouping, and add
"Days", it (again) almost does what I want, but it's really awkward because
the days are now listed is a separate column than the months. It will
become even more complicated once I start accumulating data for 2006.
If, instead of dragging Date into the Row Fields, I put it into the Page
Fields, it again ALMOST does what I want, but not quite.
I have seen pivot tables where the page field has a Date button that opens
up to show years, with little Plus signs next to them. When you click on
the plus sign, it opens up a branch list that shows the quarters, or the
months, each will little plus signs that open up further branches for
individual days. Each of these levels can be selected with little check-
boxes, so that if you want to see all the data from 2005, you just click
the 2005 box. If, on the other hand, you want to see just November, then
you open up the 2005 branch, and then just select November. You can also,
if you want, select any combination of date ranges (for instance, all of
2004, plus November of 2005, plus the first three days of December).
How the heck do I do that?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html