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...
jacovdl Without an example, my first thought is date formatting; make sure the data column is properly formatted as date (Data, Text to Columns) & the date format (format cells) is correct.
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:
