Pivot tables and dates
 

I am creating a pivot table for a department in the healthcare clinic that I
work for. They want to run a report that shows by year of the number of
people that have gotten labs done in another facility. The Start Date column
is formatted as mm/dd/yy. Is there away that I can group the dates together
by year? All I am able to do is show each individual date. Thanks for your
help. Sue

Pivot tables and dates
 

Right-click on the Date field button in the pivot table
Choose Group and Show DetailGroup
Select Years, click OK

Sue wrote:
I am creating a pivot table for a department in the healthcare clinic that I
work for. They want to run a report that shows by year of the number of
people that have gotten labs done in another facility. The Start Date column
is formatted as mm/dd/yy. Is there away that I can group the dates together
by year? All I am able to do is show each individual date. Thanks for your
help. Sue


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Pivot tables and dates
 

When I follow your steps, Excel says that I "Can not group that selection".
Any ideas???

"Sue" wrote:

I am creating a pivot table for a department in the healthcare clinic that I
work for. They want to run a report that shows by year of the number of
people that have gotten labs done in another facility. The Start Date column
is formatted as mm/dd/yy. Is there away that I can group the dates together
by year? All I am able to do is show each individual date. Thanks for your
help. Sue

Pivot tables and dates
 

If there are any blank cells in the date column, you won't be able to
group the dates in the pivot table.

http://www.contextures.com/xlPivot07.html

Or, if the dates are being treated as text, you won't be able to group
them. If so, you can change the dates back to numbers, as described he

http://www.contextures.com/xlDataEntry03.html

Sue wrote:
When I follow your steps, Excel says that I "Can not group that selection".
Any ideas???

"Sue" wrote:


I am creating a pivot table for a department in the healthcare clinic that I
work for. They want to run a report that shows by year of the number of
people that have gotten labs done in another facility. The Start Date column
is formatted as mm/dd/yy. Is there away that I can group the dates together
by year? All I am able to do is show each individual date. Thanks for your
help. Sue



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html