Forum Discussion
ShochuTaka
Apr 09, 2020Copper Contributor
SImple Pivot Table Question
I apologize if this is too basic a question, I'm a novice with Pivot Tables. In a simple pivot table with Value Fields and Row Fields, and the Value Fields are Dates, how would I sort the Dates furt...
gyankosh
Apr 09, 2020Brass Contributor
You can do one thing. Create one more column where quarters are written already e.g. Q1 Q2 and so on. Then create the pivot . It should work.
If you had shared the file, it would have been better.
Ref for pivot tables.
https://gyankosh.net/msexcel/how-to-use-pivot-tables-in-excel/#gsc.tab=0
ShochuTaka
Apr 09, 2020Copper Contributor
Thank you gyankosh , and thank you for the link.
I ended up pulling out the Quarters manually