How to extract the month in a Pivot Table

G

Guest

I have a date in excel "Period_End_Date", this date is for employee hours
worked. I create a pivot table to extract data by date & individula, then
summarize this and I need to, using the GETPIVOTTABLEDATA to get this
information into another worksheet. How do I summarize the months data?
 

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

Don't show all Pivot table subtotals 1
rolling 12 month date filter for pivot table? 2
grouping dates in a pivot table 1
Combine Pivot tables - confused about 'how-to' 7
Summarize times in a pivot table 1
Pivot Table Counting 2
Pivot Table Calculations 2
pivot table date field 1

Top