Quote:
Originally Posted by Eclypz
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 |
Thanxx
That worked!
I remember there was this option too, but somehow couldn't do it earlier.. Turns out there were a few blank cell in the row and that somehow prevented me from using the proper grouping option.