0 Replies Latest reply: Feb 3, 2015 7:02 AM by Beatriz Manjón RSS

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

    Beatriz Manjón

      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