View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cdavidson
 
Posts: n/a
Default Using a data field twice in the 'Rows' section of a pivot table.

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.