Pivot table filter is showing 2 stange dates

INN

Board Regular
Joined
Feb 3, 2021
Messages
118
Office Version
  1. 365
Platform
  1. Windows
Hi
I created a pivot table but when I tried to filter by Year, the filter is showing me 2 dates beside Year 2021 and 2021 and beside each date is symbol >
<07/01/21 and >18/12/22 Why is that? When I filter the date column in the original data set, I see everything is ok , the 2 years, 2021 and 2022. Please see screen shots. I checked
the original table, and used IsNumber function to see if all dates are formatted as a number and the answer was TRUE to all.
Thank you very much.
SNAG-0974.jpg
SNAG-0973.jpg


SalesPersonDateAmountRegion
Helen23/04/21295East
Helen26/06/21776East
Helen10/02/22511East
Helen25/04/22225East
Helen25/06/22168East
Helen10/02/22990East
Helen21/01/22624East
Helen16/07/22157East
Helen22/03/21245East
Helen01/02/22709East
Helen25/10/22242East
Helen19/05/21135EastYears(All)
Mona27/09/21223south
Mona23/03/21972southSum of Amount
Mona11/04/22278southAjit6225
Mona20/06/21647southAlexander5643
Mona12/09/22996southAli4447
Mona31/05/21355southHelen5077
Mona17/12/22296southJack3237
Ajit22/02/22701WestLinda8342
Ajit09/09/22352WestMike6933
Ajit15/01/21379WestMona3767
Ajit17/03/22736WestSam5553
Ajit20/04/22601WestGrand Total49224
Ajit04/05/21501West
Ajit19/10/21260West
Ajit06/07/22395West
Ajit13/07/21308West
Ajit22/08/22973West
Ajit19/02/21567West
Ajit07/03/22452West
Jack15/10/21256East
Jack09/07/22238East
Jack21/09/21256East
Jack09/04/22306East
Jack17/08/21194East
Jack04/04/22179East
Jack11/11/21934East
Jack29/11/22874East
Ali25/07/22868North
Ali15/07/21150North
Ali17/05/21781North
Ali28/04/22208North
Ali13/04/22625North
Ali19/08/22382North
Ali11/02/21229North
Ali31/08/21227North
Ali03/10/21358North
Ali05/05/22619North
Linda27/06/21799South
Linda28/07/21156South
Linda15/06/22733South
Linda24/04/22815South
Linda07/02/21995South
Linda19/07/22613South
Linda27/08/21353South
Linda21/07/21573South
Linda23/03/21269South
Linda16/05/22163South
Linda05/06/21944South
Linda29/08/21944South
Linda01/01/22985South
Sam20/08/22512West
Sam12/11/22888West
Sam13/03/22133West
Sam04/10/21100West
Sam18/01/22891West
Sam26/08/21397West
Sam07/02/21312West
Sam28/08/22669West
Sam19/10/21261West
Sam14/02/22255West
Sam05/03/21961West
Sam02/03/22174West
Mike02/04/22801North
Mike07/02/22464North
Mike24/12/21780North
Mike27/09/21713North
Mike29/06/22658North
Mike27/03/21449North
Mike10/03/22559North
Mike07/12/22893North
Mike30/12/21183North
Mike10/07/22831North
Mike01/10/21602North
Alexander07/01/21800South
Alexander22/12/21300South
Alexander25/08/22600South
Alexander29/03/22990South
Alexander10/07/22876South
Alexander04/02/22123South
Alexander03/09/22854South
Alexander31/10/22100South
Alexander27/08/21300South
Alexander06/08/21700South
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
If you group dates in the pivot, you will see options for values before and after your specified date ranges.
 
Upvote 0
Solution

Forum statistics

Threads
1,214,832
Messages
6,121,843
Members
449,051
Latest member
excelquestion515

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top