| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table help!
I have columns of dates. When I try and create a pivot table using all 3 columns the column headers will not all group into columns like. Hope someone can assist Sep Oct Nov Dec ? Start end close 9/17/2017 9/28/2017 10/13/2017 9/17/2017 9/28/2017 10/13/2017 9/10/2017 9/21/2017 10/6/2017 9/10/2017 9/21/2017 10/6/2017 9/10/2017 9/21/2017 10/6/2017 9/10/2017 9/21/2017 10/6/2017 9/10/2017 9/21/2017 10/6/2017 9/10/2017 9/21/2017 10/6/2017 9/17/2017 9/28/2017 10/13/2017 9/17/2017 9/28/2017 10/13/2017 11/15/2017 11/26/2017 12/11/2017 9/17/2017 9/28/2017 10/13/2017 9/17/2017 9/28/2017 10/13/2017 9/10/2017 9/21/2017 10/6/2017 9/10/2017 9/21/2017 10/6/2017 9/10/2017 9/21/2017 10/6/2017 9/10/2017 9/21/2017 10/6/2017 9/10/2017 9/21/2017 10/6/2017 Column Labels Sep Sep Total Nov Nov Total Grand Total Values 9/21/2017 9/28/2017 11/26/2017 Count of Start 11 6 17 1 1 18 Count of end 11 6 17 1 1 18 Count of close 11 6 17 1 1 18 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need a pivot table subset of a pivot table (slicer doesn't work) | Excel Discussion (Misc queries) | |||
| how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
| Child pivot table's source breaking from parent pivot table | Excel Programming | |||
| Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range) | Excel Programming | |||
| Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming | |||
Hybrid Mode
