pivot table report

H

herbzee

How to extract info from excel spreadsheet that lies between a range of
date: e.g. col. header= S DATE, i want the range of dates between:
1/1/04 & <12/31/04. I find no way to put this info in the pivot
Click to expand...
table. Help?????????????
 
K

Ken Wright

Assuming they are real dates you can just group the date field on years and
drag that into the page fields, or just deselect the other years from the
dropdown, or even just create another field in your source data and use
=YEAR(DateCell) where DateCell refers to your dates.
 
Top