Hi
I have a pivot table that has several slicers attached to it. The data is retrieved from an Access database. The data is numeric and there are 12 values: 1 -> 12. In the database, the order is correctly sorted in numeric order: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12.

The slicer orders them in this order: 0, 1, 10, 11, 12, 2, 3, 4, 5, 6, 7, 8, 9. It is set to order "Sort Data Source Order".

Is there a way to force the slicer to actually order them the way they are ordered in the DB (in correct numeric order)?

Paul