Forum Discussion
Pivot Tables!!!!!
Finally discovering the world of Pivot Tables and it is Amazing! Feel like I might never need to use formulas again. Having some trouble grouping the dates in my pivot table I created for transa...
Hi Rusty Dane
I've tried to format the date columns numerous times, but it doesn't seem to work.
Please get the data file attached
Hi jacovdl ,
Follow the steps from SergeiBaklan in his previous post, and then, in your pivot table, right click over the column that contains the Dates labels, and select: "Group"
Since you have already formated as Date, it will recognise the possibilities for grouping automatically, and will give you the following options:
