Pivot Tables Not Recognising a Section of Data In A Table

		Microsoft Office Forums > Microsoft Excel > Excel
Pivot Tables Not Recognising a Section of Data In A Table

FAQ

Thread Tools

Display Modes

12-02-2024, 02:05 AM

tomohawk

Windows 10 Pivot Tables Not Recognising a Section of Data In A Table

Office 2019

Advanced Beginner

Join Date: Sep 2020

Location: Dublin

Posts: 64

Thanks Pecoflyer

Yes - they are dates. When I Clear>Clear Formats, I get a numerical value

I tried creating a new Pivot Table from the existing Data Table and I only have an option for Date. I do not get an option for Date (Month). I'm assuming this is the issue, but I have no idea how to fix it.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Not sure how to display this data in a pivot table	makaveli80	Excel	8	04-04-2018 11:24 AM
Combine multiple tables into one pivot table in order to do trend analysis	marelisev	Excel	2	04-15-2017 08:30 AM
Data not showing in Pivot Table	MichelPierre	Excel	2	01-26-2016 10:51 AM
Extracting data, pivot tables, and maybe VBA help?	rbexcelhelp	Excel Programming	3	05-09-2015 12:13 AM
pivot table source data	hannu	Excel	0	07-03-2010 04:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:11 PM.