PivotTable: Problem with AutoSort (from A-Z) => first value is not sorted

Hello, I got the following PivotTable:

mtovb5.png (http://i61.tinypic.com/mtovb5.png )

The problem is that FR is before all the other values. Also when I sort it from Z-A "FR" is at the very end.

What am I doing wrong here?

Thanks!

Hi,

Can you please post a sample template of your workbook in excel instead of an image file?

Hello,

thanks for your answer. I attached the workbook.

You can find the pivot table in the sheet "DataLists". It takes a list from the sheet "Rawdata"

I deleted other columns due to the large file size.EPPC_v021_withoutmacros.xlsx

Thanks!

Hi,

Please check the attached file and see if the issue is resolved.




Please click on ‘ * Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue.

Yes that works perfectly Could you please tell me how you did it? I would like to do that on the original workbook (with macros and more columns in the data)

Thanks!

I plotted the Pivot Table again and saved the workbook, it works most of the times..

Not working for me

What I did:
1) Delete old Pivot
2) Made new Pivot
3) Saved it
4) Showed geo\time

Sorry to write here again, but I also found the reason WHY "FR" was always put in front:
I got a custom list "Mo, Di, Mi, Do, Fr, Sa, So" ... the weekdays in German (see your custom lists with Data tab --> Sort --> select "Custom List" from Order dropdown)

That's why Excel got confused!

Hope this may help someone in the future.

Thank you This would definitely help someone in the future..

Originally Posted by newdoverman

I downloaded your workbook and had no problem at all sorting the Pivot table correctly without making any changes at all.

Probably you dont have a customized list that contains "Fr" like me. (for German workdays)

Regards