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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
List all tables, including document structure 0
time_report_date-wise_employee-wise 6
DATE Calculations in pivot table 0
Pivot table Days to Months 0
separating date and time 5
Pivot table 0
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0

Top