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

Screenshot 2023-03-01 102140.jpg (8.9 KB, 14 views)

Please post a sample sheet ( pics are useless). Thx

__________________
Using O365 v2503 - 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

I have attached the file for reference

Attached Files

Pivot Date Test.xlsx (42.2 KB, 5 views)

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?

Could you please explain some more, I don't understand your problem. Thx

__________________
Using O365 v2503 - 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

Thanks for the support Pecoflyer

I've managed to figure it out. I can "Group" by more than one date grouping.

Problem Solved

Most welcome, even if I didn't do anything

__________________
Using O365 v2503 - 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