Notion PRD here. The Notion PRD should serve as the source of truth for this feature.

https://www.notion.so/rilldata/Pivot-row-limit-for-nested-dimensions-2c7ba33c8f5780ff8ddfdd9fd94cfeda?source=copy_link

Add row limit control to pivot tables

This PR adds a configurable row limit feature to pivot tables, allowing users to control how many child rows are displayed under each dimension.

Changes

UI Components:

• Added "Row limit" dropdown selector in pivot toolbar with options: 5, 10, 25, 50, 100, All
• Only visible in pivot table mode (not flat table mode)
• Includes tooltip explaining the limit applies to child rows under each dimension

State Management:

• Added rowLimit?: number field to PivotState (undefined = unlimited)
• Created setPivotRowLimit reducer that resets pagination, expanded state, and active cell when limit changes
• Integrated row limit into URL state for sharing/bookmarks via row_limit parameter

Data Queries:

• Applied limit to all data-fetching queries:
  • Column dimension axes
  • Row dimension axes
  • Table cell data
  • Expanded row data
  • Measure totals for sorting

Checklist:

• Covered by tests
• Ran it and it works as intended
• Reviewed the diff before requesting a review
• Checked for unhandled edge cases
• Linked the issues it closes
• Checked if the docs need to be updated. If so, create a separate Linear DOCS issue
• Intend to cherry-pick into the release branch
• I'm proud of this work!