<< Click to Display Table of Contents >>

 

The Pivot Grid Control allows you to pin columns to the left or rightmost edge. The pinned columns are never scrolled horizontally, so you can use them as a reference point for adjacent cell values.

win-pivot-fixed-pinned-columns

To pin or unpin a column, right-click the column header and select the corresponding command:

win-pivot-fixed-columns-pin-column

You cannot pin custom totals.