Date Issue In Pivot Table

		Microsoft Office Forums > Microsoft Excel > Excel
Date Issue In Pivot Table

FAQ

Thread Tools

Display Modes

03-01-2023, 11:43 PM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 949

What about having a calculated column in your Details Table (you can hide it btw.), which claculates the month of Date (like =TEXT([@Date];"mmm"), and using it in your Pivot's instead of Date?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table Date Issue	tomohawk	Excel	11	02-05-2022 11:17 PM
Issue With Date In Pivot Table	tomohawk	Excel	6	01-18-2022 08:42 AM
Excel pivot table with a DATE value field for some reason stops at a certain date	angie450	Excel Programming	2	08-19-2014 08:50 AM
Pivot Table issue	ominae	Excel	1	07-18-2014 01:40 AM
Pivot Table Issue	Grovesy	Excel	0	10-28-2012 09:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:33 AM.