| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a data field twice in the 'Rows' section of a pivot table.
In my source data, I have a 'Date' field. In my pivot table, I want to use
the 'Date' field twice: * Once to sort by 'Year' (i.e. simply changing the format to 'YYYY') * And a second time to sort by 'Month' (i.e. simply changing the format to 'MMMM') Can I do this without the requirement of adding fields to my source data? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table Repeats Names in multiple rows | Excel Discussion (Misc queries) | |||
| How do I view Pivot Table source data file and field names? | Excel Discussion (Misc queries) | |||
| Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
| Pivot table - printing specific data | Excel Discussion (Misc queries) | |||
| How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
