How To Use Report Layout In Pivot Table

Click anywhere in the PivotTable. This displays the PivotTable Tools, tab on the ribbon. On the Design tab, in the Layout group, click Report Layout, and then do one of the following: To keep related data from spreading horizontally off of the screen and to help minimize scrolling, click Show in Compact Form