View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Shweta Srivastava[_2_] Shweta Srivastava[_2_] is offline
external usenet poster
 
Posts: 13
Default Query on Group field in Pivot Table

I have a large database wherein under Date column, data is in the format "Thu
Oct 1 12:00 AM".
When I use Pivot Table Under OPTIONS-GROUP- Group Field is disabled.
I used this to group Date field to either present data by Month, quarter at
one click.
Can anybody guide me why this seems to be disabled here.
I want to present my data only by Monthwithout changing the format ""Thu Oct
1 12:00 AM".

Thanks