Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-01-2023, 03:28 AM
tomohawk tomohawk is offline Date Issue In Pivot Table Windows 10 Date Issue In Pivot Table Office 2019
Advanced Beginner
Date Issue In Pivot Table
 
Join Date: Sep 2020
Location: Dublin
Posts: 60
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, 14 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Issue In Pivot Table Pivot Table Date Issue tomohawk Excel 11 02-05-2022 11:17 PM
Date Issue In Pivot Table 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
Date Issue In Pivot Table 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 03:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft