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

C

cdavidson

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.
 
D

Dave Peterson

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.
 
Top