analyzing pivots and changes