Pivot Tables!!!!!

Question

&nbsp;Finally discovering the world of Pivot Tables and it is Amazing! Feel like I might never need to use formulas again.&nbsp;Having some trouble grouping the dates in my pivot table I created for transactions over the last 12 months.&nbsp;Any help will be appreciated!&nbsp;Cheers

preagan · Answer

Can you share an example of your problem?

rusty dane · Answer

jacovdl&nbsp; Without an example, my first thought is date formatting; make sure the data column is properly formatted as date (Data, Text to Columns) &amp; the date format (format cells) is correct.

jacovdl · Answer

Thanks, please see attached

jacovdl · Answer

Hi Rusty Dane&nbsp;&nbsp;I've tried to format the date columns numerous times, but it doesn't seem to work.Please get the data file attached

sergeibaklan · Answer

jacovdl&nbsp;
Select column B, Data-&gt;Text To Columns and on third step

Result is attached.

Forum Discussion

Pivot Tables!!!!!

6 Replies

Resources