Query on Group field in Pivot Table
Hi Shewta
Check you Data Source of your Pivot. it should come up like
"Sheet6!$G$1:$I$821" and not like "'\Documents and Settings\kali\My
Documents\[EEXXXEL.xlsx]Sheet6'!$G$1:$I$821"...if its the later you may need
to change the source or reapply the pivot function...
Hope it helps
"Shweta Srivastava" wrote:
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
|