| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Group by month in a Pivot table
On Tuesday, September 26, 2017 at 9:52:24 PM UTC+2, Peter Z. wrote:
This really worked, Hutch. Great idea, how to resolve the issue in Google Docs. Thanks. I would just add the following syntax, so the months can be ordered from left to right ascending in order: =year(A3)&"-"&if(month(A3)<10;"0";"")&MONTH(A3) P. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Group by Month in Pivot-table | Excel Discussion (Misc queries) | |||
| Pivot table - group dates per week or month | Excel Discussion (Misc queries) | |||
| Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) | |||
| Pivot Table - no group on web | Excel Discussion (Misc queries) | |||
| Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) | |||
Hybrid Mode
