How to fix/Freez Total row to the pivot table when you have many rows in your pivot.
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)
