Using a data field twice in the 'Rows' section of a pivot table.

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

Guest

In my source data, I have a 'Date' field. In my pivot table, I want to use
the 'Date' field twice:

* Once to sort by 'Year' (i.e. simply changing the format to 'YYYY')

* And a second time to sort by 'Month' (i.e. simply changing the format to
'MMMM')

Can I do this without the requirement of adding fields to my source data?

Thanks.
 
Is this a row field?

How about just grouping them by year and month?

rightclick on the date field and
choose group and show detail|group by months and years.
 

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 data 2
Pivot ungrouping on refresh? 3
Pivot Table - retains dates that are not in the source data 3
Pivot using 250,000 rows of data in Excel? 1
Pivot Table - Compare Dates & calc. % 1
Pivot Table Change to US Date Format - Why? 2
date filter in a pivot table 1
How do I stop a Pivot Table from Sorting my data (Excel 2007) 1

Back
Top