How to fix/Freez Total row to the pivot table when you have many rows in your pivot.

[Anonymous]

Hi Team,

How to fix/Freez  Total row to the pivot table when you have many rows in your pivot.

Please refer attachment for sample file.

Note:

1. when i scroll pivot data i want to see totals & Data also.

2. I dont want to see totals in a separate table also. because when data become less, then pivot-table , totals table will have gap in between.

(Acceptable: is there any development which will adjust dynamically the GAP/Space in between pivot and totals tables when records are very less in pivot table)