REVscene Automotive Forum - View Single Post - Excel help! Converting date -> month for pivot table

Eclypz · 05-06-2010, 12:27 PM

You can group columns in pivot tables
In your pivot table, Right click the date column -> group -> month
(Based off of memory, so it might not be exact)
Posted via RS Mobile

05-06-2010, 12:27 PM	#5
Eclypz RS.net, helping ugly ppl have sex since 2001 Join Date: Apr 2001 Location: 604 Posts: 9,795 Thanked 106 Times in 55 Posts Failed 5 Times in 2 Posts	You can group columns in pivot tables In your pivot table, Right click the date column -> group -> month (Based off of memory, so it might not be exact) Posted via RS Mobile