Grouping DATES in a pivot tables

G

Guest

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.
 
P

Peo Sjoblom

It must be text, try this

=ISTEXT(x)

where x is a cell with these date/time values

if it returns TRUE it is text and you cannot group text,
if you copy an empty cell (formatted as dates), select the values and do
edit>paste special and select add it should convert it to dates
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping dates in pivot table 3
Pivot Table and Grouping Problem 3
Pivot table date grouping 2
Pivot table field. 2
Pivot table problem 4
pivot table counting 1
Grouping in a Pivot Table 1
Pivot Tables and Fiscal Year 2

Top