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
|