Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to sort and maintain static cells in a pivot table?

Hello,

I have a problem when sorting a pivot table like this: In this example, I have two dimensions A,B and my main problem is that when I try to select one 'square' for instace, A=feb and B=january,=18,54%.


My pivot table remains like this ; Notice that in the x-axis ,the cell of January has been shifted to the right while the others ( feb and march) have been exchanged.On the other hand, in the y-axis, all the cells except for 'feb' have disappeared.

What I would like to get it's this order, just having all the cells static and ordered by the name of the month.


I appreciate any suggestions.

Many thanks,

B

0 Replies