Thread
: [Solved]
Date Issue In Pivot Table
View Single Post
03-01-2023, 11:43 PM
ArviLaanemets
Windows 8
Office 2016
Expert
Join Date: May 2017
Posts: 932
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?
ArviLaanemets
View Public Profile
Find all posts by ArviLaanemets