Grouping in Pivot Table

M

Minerva

I have a "sheet1" with columns of data like Name, Location, JobLevel, Skills
and AvailableFromDate.
I have created a pivot for the data with 'JobLevel' and 'AvailableFromDate'
as COLUMN fields in the pivot, but I am unable to group the
'AvailableFromDate' field (based on 7 day-week criteria). In "sheet1" the
column 'AvailableFromDate' has some blank cells where the date is not
available...are these empty cells a problem for grouping?
Can this be solved without creating a separate sheet for the pivot report to
be generated?
Is there a way to group a field which has blank cells as values in the
master data?
Thanks for your help.
 
R

Roger Govier

Hi

It is the blank cells that the PT doesn't like when trying to group.
A way around this that I have used in the past, would be to change all
Blank "available from" dates way into the future (=TODAY()+367 ??),
rather than blank, and then exclude those that are over a year away.
 
M

Minerva

Thanks Roger, I think that will do for now.

Roger Govier said:
Hi

It is the blank cells that the PT doesn't like when trying to group.
A way around this that I have used in the past, would be to change all
Blank "available from" dates way into the future (=TODAY()+367 ??),
rather than blank, and then exclude those that are over a year away.
Click to expand...
 
Top