Adding Same Field 2x in an Excel 2007 Pivot Table
 

Hello,

Is there a way to add the same field twice in a Pivot Table? I'm trying to
add a Date field in the Row section of the Pivot Table twice but it does not
allow me to do it. I need to have it in there twice since one of the fields
will be group week and the second will show each individual day. I thought
this was possible but I cant seem to make it work.

Any help/suggestions will be greatly appreciated.