Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
What you want is not possible. The pivot table does not have an option to fix the N-top rows.