#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Please post a sample sheet ( pics are useless). Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
I have attached the file for reference
|
#4
|
|||
|
|||
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?
|
#5
|
||||
|
||||
Could you please explain some more, I don't understand your problem. Thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
|||
|
|||
Thanks for the support Pecoflyer
I've managed to figure it out. I can "Group" by more than one date grouping. Problem Solved |
#7
|
||||
|
||||
Most welcome, even if I didn't do anything
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Pivot Table Date Issue | tomohawk | Excel | 11 | 02-05-2022 11:17 PM |
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 |
Pivot Table issue | ominae | Excel | 1 | 07-18-2014 01:40 AM |
Pivot Table Issue | Grovesy | Excel | 0 | 10-28-2012 09:08 PM |