P
Peter
In the past I've imported 3rd party data via ODBC into a pivot table ('SS1')
& have successfully grouped the DATE field into columns eg: Jan, Feb etc.
However I now need to add on intermediate spreadsheet ('SS2') to rearrange
the data from SS1 and convert text fields into values etc. I want to produce
a revised pivot from SS2. My problem is that the DATE record from SS1 now
appears as a date/time record in SS2 and will no longer group. I've tried all
sorts of formating etc but still get the "can't group that selection"
message. Any ideas? Many thanks.
& have successfully grouped the DATE field into columns eg: Jan, Feb etc.
However I now need to add on intermediate spreadsheet ('SS2') to rearrange
the data from SS1 and convert text fields into values etc. I want to produce
a revised pivot from SS2. My problem is that the DATE record from SS1 now
appears as a date/time record in SS2 and will no longer group. I've tried all
sorts of formating etc but still get the "can't group that selection"
message. Any ideas? Many thanks.