Pivot Table shows same month twice!

Hi!
A colleague at work asked me to look into a problem he is having.
The problem has to do with a pivot table he is using and it shows it self like this. He has data from every month, but for some reason Excel removes may, and shows the month of June twice.
It looks like this then; month: 1, 2, 3, 4, 6, 6, 7, 8, 9, 10, 11, 12. May exists but is shown as June, minor issue but why does it happen?
After searching the web I could not find a solution. Hopefully somebody here knows!

Attach a sample workbook (not a picture!). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

As you can see here, a "quick fix" was to use text in order to show month 5, may (this would be the after picture, how we would ike for it to be but without the manual override). The problem we are having is that the pivot table shows the wrong thing. It should display one of each month and not 2 "6".

I would appreciate if someone could take a look at this and help me understand what is wrong!

Thanks for the quick response! We still have problems with the months though. It seems as nothing has changed, are we doing something wrong? Can you see the months in correct order for all years?

Originally Posted by Erik199

Thanks for the quick response! We still have problems with the months though. It seems as nothing has changed, are we doing something wrong? Can you see the months in correct order for all years?

Are you talking to ....?

Anybody who has seen the file, because the original problem is still there, the pivot table shows the wrong months, no may exept the one we forced with text, and 2 junes for some unknown reason to us.
I'm just wondering when you (person who tries to solve the problem) try to use the pivot table, do you see every month in the correct order with no duplicates, or do you get the same result as we do.

Here is what I still see for some reason.

Yes, both right after opening it, and after updating the table. Is there something wrong with our Excel perhaps?

I said recreate not refresh PivotTable. It means: delete all your PivotTables and create them from the begining. All on my file.

ad rem:
check date column on your workbook. change format to General and if you'll see numbers from the top to the bottom dates are ok, so change back to the short date format.
I don't understand why on Month column two formulas are used:
=MONTH([@Datum])
=TEXT(MONTH([@Datum]), "5") ???

there should be one: =MONTH([@Datum]) from the top to the bottom

but because maybe you need, from some reason, TEXT formula, I added double unary =--TEXT(MONTH([@Datum]), "5") to change text number to number number without changing formula construction.

Now you should delete your Pivots and create them again
Did you check on my Pivot Month filter? There are no duplicates.
In your example duplicates exist because few rows of month are as text, few are as a number. For Excel these are different values.

I changed formula on columns: År, Månad, Vecka to:
=IF(A2="","",YEAR([@Datum]))
=IF(A2="","",MONTH([@Datum]))
=IF(A2="","",WEEKNUM([@Datum]))

IT WORKS! Thank you all for the help!

You are welcome

If that takes care of your original question, & to say Thanks and for better Motivation, please

1. click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
   then
2. select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.

If you did it already - ignore it.
Thank you.

Will do! I am kinda the IT guy at this company and don't really know Excel on this level, but the people who asked me to help solve the problem understood what you said Sandy, I did not to the full extend. That's why I more wanted a solution than a how to but your explanation will help us avoid this in the future, so thank you!

You are welcome and have a nice Excel-ing