Notifications
Clear all
Topic starter
Hello,
I have a table that's several hundred thousand rows. It contains a date field like this: dd/mm/yyyy. When I summarize it with a Pivot Table, Excel adds fields for Year and Quarter, but the original date field won't display. Please see the attached sample file. This does not happen when the table is small.
How can I keep the original format?
Paul
Posted : 20/03/2019 1:17 pm
Since there is no attachment I can't show you, but you can ungroup this in the pivot table. Somewhere on the ribbon you can find this when you select a cell in the pivot table.
Frans
Posted : 21/03/2019 6:43 am
Topic starter
Thanks, Frans. That worked.
Posted : 21/03/2019 12:35 pm
