How to lock total, within a pivot table, when scrolling?

[marcus_steggall]

Afternoon all,

Quick question, I attach an example of a simple pivot table... where you have to scroll down, to see the total line.

Is it possible, to have the total visible, without having to scroll down the list? (like in a straight table).

I don't want to re-size the pivot table to show a long list... as space is limited.

Any help, be much appreciated.

[MK_QSL]

Go to presentation tab

Subtotals

Tick Subtotals on Top..

This is the best option.