Thread: [Solved] Date Issue In Pivot Table
View Single Post
 
Old 03-01-2023, 11:43 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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?
Reply With Quote