| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Grouping in Pivot Table
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Grouping By Date in Pivot Table | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| grouping data in a pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Problems | Excel Discussion (Misc queries) | |||
Threaded Mode
