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...
jacovdl
Sep 20, 2019Copper Contributor
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
SergeiBaklan
Sep 20, 2019Diamond Contributor
- ElipumMar 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: