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.