Forum Discussion
slohombre
Feb 04, 2021Brass Contributor
Date Hierarchy Problem - Want actual date not Month
Hi, all. I am putting together a simple pivot table and I am getting the Month in my date columns instead of the actual date format of 5/1/2021. How do I tell the pivot table to give me the date ...
Riny_van_Eekelen
Feb 04, 2021Platinum Contributor
slohombre Try right-clicking on a month name and select "Ungroup".
- slohombreFeb 04, 2021Brass Contributor
Riny_van_Eekelen Bingo. That worked. Thank you!
- Riny_van_EekelenFeb 04, 2021Platinum Contributor
slohombre You are welcome!