Thread: [Solved] Date Issue In Pivot Table
View Single Post
 
Old 03-01-2023, 03:28 AM
tomohawk tomohawk is offline Windows 10 Office 2019
Advanced Beginner
 
Join Date: Sep 2020
Location: Dublin
Posts: 48
tomohawk is on a distinguished road
Default Date Issue In Pivot Table

I have a set of data and I use pivot tables to analyse.

The column header is Month.

I've added February data but when I refresh the pivot table I get the "Jan" and "Feb" columns (But with additional (min/max) columns. When I unselect the ">" or "<", I lose data.

Also, when I remove date from the pivot table column and add it back, I do not get the Date/Year/Month option.

Tommy
Attached Images
File Type: jpg Screenshot 2023-03-01 102140.jpg (8.9 KB, 12 views)
Reply With Quote