grouping data in a pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello I have a excel spreadsheet that I need to change into a pivot table.
The dates are listed in the date column daily. (1/1/01= $10 , 1/2/01= $
10,1/3/01= 10) I want the pivot table to group the dates and give me the sums
of a specific month. Jan 01 = $30. The reason I need to do this is because
the pivot table is also stating that I have too many columns and it won’t
show all of my data at one time.
 
If you have real dates in that column, you can group that field by month (and
year) inside the pivottable.

Just rightclick on the field and choose "Group and show detail". Group by
months (and years??).
 
Re: too many columns. Sounds like you should probably make that a row
field in the pivot table.
 
You must log in or register to reply here.

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

convert date to text month 2
Pivot Table date format 1
Pivot table field. 2
Grouping Time in Pivots. 2
How do I convert dates to months in Pivot Tables? 1
Countifs or a pivot 1
Pivot Table Date Format 2
Pivot Table Summarizing Quirk - Please Help 1

Back
Top