Hi......help.
I am trying to pivot some data. The source data contains dates, such as 01/07/2016 (1st July 2016).
However, when I select the date to incorporate into my pivot table the date 01/07/2016 does not appear. Instead, I have columns headed month, quarter & year.
Years Quarters Date...