Forum Discussion
jacovdl
Sep 19, 2019Copper Contributor
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...
SergeiBaklan
Sep 20, 2019Diamond Contributor
Elipum
Mar 31, 2020Brass Contributor
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: