Pivot Table Question

  • Thread starter Thread starter Connie Martin
  • Start date Start date
C

Connie Martin

In the page area, I have a "Month Year" drop-down to select from. There are
several of the same month and year, like JUL 2006. They are all listed
individually. Is there anyway to group them, so that I select it I get all
orders for JUL 2006? I'm using Excel 2003. I've been digging, but can't
find anything yet. Thank you. Connie
 
There are a couple possibilities.

1) The selections may have spaces before, in the middle, or after the name.

2) The selections are full dates (7/1/08, 7/4/08), formatted as month/year.

Go to your data sheet, sort by date and copy and paste one on top of the rest.
 
Sean, it's the #2 scenario, but your solution didn't change anything. Connie
 
In the pivot table, you can group the date field by year and month.
Then, move the year and month fields to the page area, and select from
the dropdown lists
 
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

Pivot Table by Financial Year 2
Pivot Table Question 4
Pivot table 3
Calculating total amount in a Pivot Table 1
count total month per year 2
Pivot Table/Chart Grouping 4
Pivot Table Grouping or Calculated Field 2
pivot table help 2

Back
Top