Hi
I have a Pivot table which as a filed for the rows called ProdGroup. It as numbers from 1 to 12 and I have managed to do the totals and subtotals on each group.
However the numbers for the columns are out of number order, so instead of going from 1 to 12 it is putting the 1's first so I have
1
10
11
12
2
3
4
Up to 9
How can I get it so it goes in order from 1 to 12. I have tried grouping but it just wont work, I have tried several sorts but still no luck.
Any advise please.
I have a Pivot table which as a filed for the rows called ProdGroup. It as numbers from 1 to 12 and I have managed to do the totals and subtotals on each group.
However the numbers for the columns are out of number order, so instead of going from 1 to 12 it is putting the 1's first so I have
1
10
11
12
2
3
4
Up to 9
How can I get it so it goes in order from 1 to 12. I have tried grouping but it just wont work, I have tried several sorts but still no luck.
Any advise please.