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