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.

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

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.



cdavidson wrote:

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.

--

Dave Peterson

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

Thanks. Didn't know you could use the 'Group' function that way.



"Dave Peterson" wrote:

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.



cdavidson wrote:

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.

--

Dave Peterson