| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date problem in Pivot Tables when using SQL as a Data Source.
Just in case anyone else is having this problem, the solution is to use
the "Group By..." function within the pivot table. By using this function you can group dates together and have them show up as actual TEXT dates such as Jan, Feb, Mar instead of 1, 2 and 3. Thanks Steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot tables - Editing the data source shared by multiple pivot ta | Excel Discussion (Misc queries) | |||
| Data Source in Pivot Tables | Charts and Charting in Excel | |||
| Multiple Pivot tables using the same source data | Excel Discussion (Misc queries) | |||
| Source Data in Pivot Tables | Excel Worksheet Functions | |||
| Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Threaded Mode
