Hi Sovietchild,

xlnitwit is correct, although you may also need to make a selection in the frame to the right of where you made the selection 'previous'. Based on what I see in your file, you have not included labels so your pivot table just says 'column 1' in the rows area. This is the one you may need to select.

Hope this helps.