Support for Freezing Grand Totals During Pivot Table Paging Validated

Paging allows large datasets to be loaded and displayed page by page in the Pivot Table. However, a current limitation exists: row and column grand total values cannot be frozen during page navigation when paging is enabled.

Current Behavior:

• Paging dynamically loads and renders data based on the current page using a single-page rendering approach.
• For example, if the Pivot Table contains 100 unique rows and the RowPageSize is set to 10:
  • The table will render 10 rows per page, resulting in 10 pages.
• Grand total rows and columns, typically shown at the end of the Pivot Table:
  • Are only generated on the last page.
  • Are not available for freezing during initial render.
  • This makes it difficult to reference grand totals while navigating through earlier pages.

Enhancement Requirement:

To improve usability and analytical convenience, the following enhancements are suggested:

• Freeze row grand totals (usually displayed at the bottom) while navigating to the last row page.
• Freeze column grand totals (usually displayed at the far right) while navigating to the last column page.
• Ensure consistent behavior across all configurations, including when grand totals are positioned at the top or bottom.

Benefit:
This enhancement would allow users to maintain visibility of grand total values throughout page navigation, improving data analysis and decision-making.