Pivot Features

Pivot Grid Feature List

Status legend:

• Existing ✅ - implemented now.
• Partial ☑️ - foundation exists, but product/API/UX work is still needed. — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• Planned 🚧 - roadmap item.

1. Data Source

Local data

• ✅ Static array data source
• ✅ Immutable data source support
• ✅ Mutable data source support
• ☑️ Incremental row updates — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ ☑️ row updates — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Batch row updates — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Append rows — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Remove rows — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Replace rows
• ✅ Data normalization for generated pivot rows/cells
• ☑️ Data type inference — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Schema inference — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Manual schema definition through dimensions
• ✅ Direct grid.pivot configuration
• ✅ Legacy additionalData.pivot configuration
• ✅ Restore original source, columns, grouping, and pinned rows on clearPivot()
• ✅ Generated pivot row metadata
• ✅ Generated pivot column metadata

Remote data

• ✅ Server-side data source contract
• ☑️ Lazy loading — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Pagination-aware loading
• ☑️ Cursor-based loading — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Offset/limit loading
• 🚧 Streaming data source
• 🚧 WebSocket data source
• ✅ REST data source through HttpPivotRemoteStore
• ☑️ GraphQL data source through custom adapter/store — Why partial: foundation exists through custom adapter/store, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Custom data adapter through PivotEngineAdapter
• ✅ Request cancellation
• ☑️ Retry logic — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Loading state handling
• ✅ Error state handling
• ✅ Stale response guard
• ✅ HTTP auth header provider
• ✅ HTTP request lifecycle hooks
• ✅ In-flight remote request deduplication

Hybrid data

• ☑️ Client-side cache — Why partial: cache keys/state foundations exist, but full lifecycle, invalidation, and observability are not complete.
• ✅ Server-side aggregation with client rendering
• ✅ Client-side aggregation with remote-style engine adapter
• ☑️ ☑️ pre-aggregation — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• 🚧 Incremental cache refresh
• 🚧 Optimistic updates
• 🚧 Offline mode
• 🚧 Local-first mode

---

2. Field Model

Field metadata

• ✅ Field name
• ✅ Field label through RevoGrid column name
• ✅ Field type through RevoGrid column/type metadata
• ✅ Field description
• ☑️ Field category — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Field icon — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Field visibility through hidden dimension metadata and show-hidden field filtering
• ☑️ Field permissions through remote field registry metadata — Why partial: foundation exists through remote field registry metadata, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Field default format through column config/templates/parsers — Why partial: foundation exists through column config/templates/parsers, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Field default aggregation through value definitions and dimension aggregators
• ✅ Field default sorting through RevoGrid column sort metadata
• ✅ Field default filtering through RevoGrid column filter metadata
• ☑️ Field nullable flag — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• 🚧 Field unique values provider
• ✅ Field value formatter through cell templates/parsers
• ✅ Field value parser through RevoGrid column parser support
• ✅ Server-side public selector registry
• ✅ Backend expression metadata for field registry
• ✅ Allowed filter operations metadata
• ✅ Allowed summary metadata
• ✅ Allowed group interval metadata
• ✅ Drilldown visibility metadata

Field types

• ✅ Text field
• ✅ Number field
• ☑️ Integer field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Decimal field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Currency field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Percentage field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Date field
• ☑️ Date-time field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Time field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Boolean field
• ☑️ Enum field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Multi-enum field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Object field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Array field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ JSON field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Link field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Image field — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Custom field type through RevoGrid column types

Field categories

• ✅ Dimension fields
• ✅ Measure fields
• ☑️ Calculated fields — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ✅ Hidden fields through hidden dimension metadata
• ☑️ System fields — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Technical fields — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ User-defined fields — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.

---

3. Pivot Layout Areas

Rows area

• ✅ Add row dimension
• ✅ Remove row dimension
• ✅ Reorder row dimensions
• ✅ Nested row dimensions
• ✅ Row hierarchy
• ✅ Row group expansion
• ✅ Row group collapse
• ✅ Row group sorting through grid sorting/dimension comparers
• ☑️ Row group filtering — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ✅ Row group formatting through column templates/parsers
• ✅ Row group custom renderer through grouping label template

Columns area

• ✅ Add column dimension
• ✅ Remove column dimension
• ✅ Reorder column dimensions
• ✅ Nested column dimensions
• ✅ Column hierarchy
• ✅ Column group expansion
• ✅ Column group collapse
• ✅ Column group sorting through dimension comparers
• ☑️ Column group filtering — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ✅ Column group formatting through templates/placeholders
• ☑️ Column group custom renderer — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.

Values area

• ✅ Add measure
• ✅ Remove measure
• ✅ Reorder measures
• ✅ Multiple measures
• ✅ Measure grouping in generated columns
• ✅ Measure display on columns
• ✅ Measure display on rows
• ✅ Measure aliases through PivotConfigValue.label/name
• ✅ Measure formatting through column config/templates/parsers
• ✅ Measure custom renderer through RevoGrid cell templates

Filters area

• ✅ Add report filter to configuration/panel
• ✅ Remove report filter from configuration/panel
• ✅ Reorder filters
• ☑️ Global filters — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ✅ Field-level filters through RevoGrid filter collection
• ✅ Subtotal and grand-total rows are excluded from filter matching and selection-filter option lists
• ☑️ Context filters — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• 🚧 Hidden filters
• 🚧 Locked filters

---

4. Row Pivoting

Row grouping

• ✅ Single-level row grouping
• ✅ Multi-level row grouping
• ✅ Nested row groups
• ✅ Hierarchical row grouping
• ✅ Tree-style row grouping through RevoGrid grouping
• ✅ Flat row grouping
• ☑️ Compact row grouping — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Outline row grouping — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Tabular row grouping — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.

Row group behavior

• ✅ Expand row group
• ✅ Collapse row group
• ✅ Expand all row groups through collapsed: false
• ✅ Collapse all row groups through collapsed: true
• ☑️ Expand to level — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Collapse to level — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Preserve expansion state
• ✅ Initial expansion state
• 🚧 Lazy group expansion
• 🚧 Async group expansion

Row group display

• ✅ Group indentation through RevoGrid grouping
• ✅ Group icons through RevoGrid grouping
• ✅ Group labels
• ☑️ Group counts — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Group summaries through groupAggregations
• 🚧 Group badges
• ☑️ Group path display — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Custom group label
• ✅ Empty group label through groupLabels.empty
• ✅ Null group label through groupLabels.null

---

5. Column Pivoting

Column grouping

• ✅ Single-level column grouping
• ✅ Multi-level column grouping
• ✅ Nested column groups
• ✅ Dynamic pivot columns
• ✅ Generated pivot columns
• ✅ Hierarchical column headers
• ✅ Multi-row column headers
• ✅ Column group headers
• ✅ Column leaf headers

Column group behavior

• ✅ Expand column group
• ✅ Collapse column group
• ✅ Expand all column groups
• ✅ Collapse all column groups
• ☑️ Expand columns to level — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Collapse columns to level — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Preserve column expansion state
• 🚧 Lazy column group expansion
• 🚧 Async column group expansion

Column group display

• ✅ Column group labels
• ☑️ Column group icons — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Column group summaries through subtotal/grand-total/collapsed buckets
• ☑️ Column group counts through hidden-count metadata — Why partial: foundation exists through hidden-count metadata, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Column group badges
• ☑️ Custom column group renderer — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ✅ Empty column group label through groupLabels.empty
• ✅ Null column group label through groupLabels.null
• ✅ Flat column header mode
• ✅ Merged value headers through mergeValueHeaders
• ✅ Collapsed column placeholder header/cell templates
• ✅ Collapsed column hidden leaf count metadata

---

6. Aggregations

Basic aggregations

• ✅ Sum
• ✅ Count
• ☑️ Count non-empty — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Count empty — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Count distinct through distinct
• ✅ Average
• ✅ Minimum
• ✅ Maximum
• ✅ Median
• ✅ Mode
• ✅ First value
• ✅ Last value
• ✅ Range
• 🚧 Product

Statistical aggregations

• ✅ Variance
• ☑️ Sample variance — Why partial: base grid behavior exists, but Pivot-specific grouped rows, generated columns, and totals need dedicated UX/accessibility coverage.
• ✅ Population variance
• ✅ Standard deviation through stdDev
• ☑️ Sample standard deviation — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Population standard deviation through stdDev
• 🚧 Percentile
• 🚧 Quartile
• 🚧 Interquartile range
• 🚧 Skewness
• 🚧 Kurtosis
• 🚧 Correlation
• 🚧 Covariance

Financial aggregations

• 🚧 Weighted average
• ✅ Running total through advanced accSum aggregator
• ✅ Cumulative sum through advanced accSum aggregator
• 🚧 Year-to-date
• 🚧 Quarter-to-date
• 🚧 Month-to-date
• 🚧 Growth rate
• ☑️ Percentage change through custom aggregation — Why partial: foundation exists through custom aggregation, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Contribution percentage through advanced %oftotal aggregator
• ☑️ Margin percentage through custom aggregation — Why partial: foundation exists through custom aggregation, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Compound annual growth rate

Custom aggregations

• ✅ Custom aggregation function
• ☑️ Multi-field aggregation — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Aggregation dependencies — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Aggregation context — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Aggregation metadata — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• 🚧 Aggregation lifecycle hooks
• 🚧 Async aggregation
• ☑️ Server-defined aggregation — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ✅ User-defined aggregation
• ✅ Streaming accumulator path for common client aggregators
• ✅ Custom collapsed-column aggregation override

---

7. Calculated Fields

Calculated dimensions

• ☑️ Formula-based dimension through precomputed/custom source fields — Why partial: foundation exists through precomputed/custom source fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Date-derived dimension through precomputed/custom source fields — Why partial: foundation exists through precomputed/custom source fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Text-derived dimension through precomputed/custom source fields — Why partial: foundation exists through precomputed/custom source fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Bucketed dimension through remote group intervals or precomputed fields — Why partial: foundation exists through remote group intervals or precomputed fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Conditional dimension through precomputed/custom source fields — Why partial: foundation exists through precomputed/custom source fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Lookup-based dimension through precomputed/custom source fields — Why partial: foundation exists through precomputed/custom source fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Custom function dimension through precomputed/custom source fields — Why partial: foundation exists through precomputed/custom source fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

Calculated measures

• ☑️ Formula-based measure through custom aggregation/precomputed fields — Why partial: foundation exists through custom aggregation/precomputed fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Measure-to-measure calculation — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Ratio calculation — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Percentage calculation — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Difference calculation — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• 🚧 Difference from previous
• 🚧 Difference from parent
• 🚧 Difference from grand total
• ☑️ Running calculation through accSum — Why partial: foundation exists through accSum, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Window calculation

Formula system

• 🚧 Formula editor
• 🚧 Formula validation
• 🚧 Formula autocomplete
• 🚧 Formula syntax highlighting
• 🚧 Formula error display
• 🚧 Formula dependency tracking
• 🚧 Safe formula execution
• 🚧 Custom formula functions
• 🚧 Formula versioning

---

8. Totals and Subtotals

Grand totals

• ✅ Row grand total
• ✅ Column grand total
• ✅ Both-axis grand total
• ✅ Enable/disable grand totals
• 🚧 Grand total position top
• ✅ Grand total position bottom through pinned bottom rows
• 🚧 Grand total position left
• ✅ Grand total position right as generated total columns
• ✅ Sticky grand total row through pinned bottom rows
• ☑️ Sticky grand total column — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.

Subtotals

• ✅ Row subtotals
• ✅ Column subtotals
• ✅ Per-level subtotals
• ✅ Per-field subtotals through totals.disabledSubtotals
• ✅ Enable/disable subtotals per field through totals.disabledSubtotals
• 🚧 Subtotal position before children
• ✅ Subtotal position after children
• ✅ Custom subtotal label
• ☑️ Custom subtotal aggregation — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ☑️ Sticky subtotals — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Suppress single-child subtotals
• ✅ Suppress redundant grand total when single leaf

Total formatting

• ✅ Grand total styling
• ✅ Subtotal styling
• ✅ Total row custom renderer through row column templates
• ✅ Total column custom renderer through value column templates
• ✅ Total value formatter through column templates/parsers
• ✅ Total label formatter through label templates/config labels
• ✅ Total cells readonly behavior

---

9. Filtering

Basic filters

• ✅ Equals
• ✅ Not equals
• ✅ Contains
• ✅ Not contains
• ✅ Starts with
• ✅ Ends with
• ☑️ Is empty — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Is not empty — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Is null — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Is not null — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ In list
• ✅ Not in list

Number filters

• ✅ Greater than
• ✅ Greater than or equal
• ✅ Less than
• ✅ Less than or equal
• ✅ Between through slider range mapping
• ☑️ Not between — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Positive — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Negative — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Zero — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• 🚧 Top N
• 🚧 Bottom N
• 🚧 Above average
• 🚧 Below average

Date filters

• ☑️ Date equals — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Date before — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Date after — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Date between — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• 🚧 Today
• 🚧 Yesterday
• 🚧 Tomorrow
• 🚧 This week
• 🚧 Last week
• 🚧 Next week
• 🚧 This month
• 🚧 Last month
• 🚧 Next month
• 🚧 This quarter
• 🚧 Last quarter
• 🚧 This year
• 🚧 Last year
• 🚧 Year-to-date
• 🚧 Rolling period

Pivot-specific filters

• ☑️ Pre-aggregation filters — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ☑️ Post-aggregation filters — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ☑️ Group filters — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ☑️ Measure filters — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• 🚧 Subtotal filters
• 🚧 Grand total filters
• ☑️ Axis filters — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ☑️ Context filters — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ✅ Report filters in layout state/panel
• 🚧 Hidden filters
• 🚧 Locked filters

Filter UX

• ✅ Filter popup through RevoGrid filters
• ✅ Filter chips through exported Pivot filter chip helpers
• ☑️ Filter sidebar — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ✅ Filter search through RevoGrid filters where enabled
• 🚧 Filter presets
• 🚧 Filter history
• ✅ Clear filter through RevoGrid filters
• ✅ Clear all filters through RevoGrid filters
• 🚧 Save filter set
• 🚧 Restore filter set

---

10. Sorting

Field sorting

• ✅ Ascending sort
• ✅ Descending sort
• ✅ No sort
• ✅ Multi-field sort in local grid sorting
• ☑️ Natural sort — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ☑️ Locale-aware sort — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ☑️ Case-sensitive sort — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ☑️ Case-insensitive sort — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ✅ Custom comparator through RevoGrid cellCompare

Pivot sorting

• ✅ Sort row groups by label
• ☑️ Sort row groups by measure — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ☑️ Sort row groups by subtotal — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ☑️ Sort row groups by grand total — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ✅ Sort column groups by label
• ☑️ Sort column groups by measure — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ☑️ Sort column groups by subtotal — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ☑️ Sort column groups by grand total — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ✅ Sort leaf rows
• ✅ Sort leaf columns

Advanced sorting

• ☑️ Sort by hidden measure — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ☑️ Sort by calculated field — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ☑️ Sort by custom order — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• 🚧 Sort by manual order
• ☑️ Sort by hierarchy order — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ✅ Sort by server-side order
• ✅ Preserve sort after refresh in remote controller state
• ✅ Field-panel sort toggle
• ✅ Remote sort descriptor mapping

---

11. Grouping Helpers

Date grouping

• ✅ Group by year in remote contract
• 🚧 Group by half-year
• ✅ Group by quarter in remote contract
• ✅ Group by month in remote contract
• 🚧 Group by week
• ✅ Group by day in remote contract
• 🚧 Group by hour
• 🚧 Group by minute
• 🚧 Fiscal year grouping
• 🚧 Fiscal quarter grouping
• 🚧 Custom calendar grouping
• ✅ Group by day of week in remote contract

Number grouping

• ✅ Fixed interval buckets in remote contract
• 🚧 Auto buckets
• ☑️ Custom buckets through precomputed/custom fields — Why partial: foundation exists through precomputed/custom fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Range buckets in remote contract
• ☑️ Histogram buckets — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Quantile buckets — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Negative/positive buckets — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.

Text grouping

• ☑️ First letter grouping through precomputed/custom fields — Why partial: foundation exists through precomputed/custom fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Prefix grouping through precomputed/custom fields — Why partial: foundation exists through precomputed/custom fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Regex grouping through precomputed/custom fields — Why partial: foundation exists through precomputed/custom fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Custom text buckets through precomputed/custom fields — Why partial: foundation exists through precomputed/custom fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Case-insensitive grouping — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Locale-aware grouping — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.

Custom grouping

• ☑️ Function-based grouping through precomputed/custom fields — Why partial: foundation exists through precomputed/custom fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Lookup-based grouping through precomputed/custom fields — Why partial: foundation exists through precomputed/custom fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Hierarchy-based grouping through row/column dimensions — Why partial: foundation exists through row/column dimensions, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Server-side grouping contract
• ☑️ User-defined grouping — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.

---

12. Field Panel

Field list

• ✅ Available fields list
• ✅ Field search
• ☑️ Field categories — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Field icons — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Field descriptions
• ☑️ Field type badges — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Hidden fields toggle through filterPivotDimensions(..., { showHidden })
• 🚧 Favorite fields
• 🚧 Recently used fields

Drag and drop

• ✅ Drag field to rows
• ✅ Drag field to columns
• ✅ Drag field to values
• ✅ Drag field to filters
• ✅ Reorder fields
• ✅ Move field between areas
• 🚧 Duplicate field
• ✅ Remove field
• ☑️ Drop validation — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Configurable field dragging
• ✅ Configurable field removing

Field configuration

• ☑️ Rename field through dimension config — Why partial: foundation exists through dimension config, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Change aggregation
• ☑️ Change format through dimension config — Why partial: foundation exists through dimension config, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Change sort
• ☑️ Change filter — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ☑️ Change display mode — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Change subtotal settings — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• 🚧 Change null handling
• ☑️ Change permissions through field registry/server policy — Why partial: foundation exists through field registry/server policy, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Open advanced settings
• ✅ Configurable area visibility
• ✅ Localized field panel text

---

13. Pivot Builder UX

Visual builder

• ✅ Drag-and-drop pivot builder
• ✅ Sidebar builder
• 🚧 Modal builder
• ☑️ Inline builder — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Compact builder
• ☑️ Advanced builder — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• 🚧 Beginner mode
• 🚧 Expert mode
• ✅ Standalone configurator API
• ✅ Standalone field panel API
• ✅ External configurator mount target

Configuration UX

• ✅ Live preview
• ☑️ Apply/cancel mode — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Auto-apply mode
• ✅ Reset layout
• 🚧 Undo layout change
• 🚧 Redo layout change
• ☑️ Save configuration through remote store state API — Why partial: foundation exists through remote store state API, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Load configuration through remote store state API — Why partial: foundation exists through remote store state API, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Share configuration
• ✅ Public pivot config update event
• ✅ Preventable config update event flow

Validation UX

• ☑️ Invalid field warning — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Missing measure warning — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• 🚧 Circular calculated field warning
• ✅ Unsupported server aggregation warning/error
• ✅ Server limitation warning
• ✅ Performance warning

---

14. Display Modes

Pivot table layouts

• ☑️ Compact layout — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Outline layout — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Tabular layout — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Flat layout
• ✅ Matrix layout
• ✅ Tree layout through grouped rows
• ☑️ Excel-like layout — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Minimal layout — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Dense layout — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Comfortable layout — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.

Measure display

• ✅ Measures as columns
• ✅ Measures as rows
• ✅ Measures nested under columns
• ✅ Measures nested under rows
• ☑️ Measures before dimensions through rowTree — Why partial: foundation exists through rowTree, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Measures after dimensions
• ✅ Single measure mode
• ✅ Multi-measure mode
• ✅ Advanced rowTree with $values pseudo-field
• ✅ Row-tree validation

Header display

• ✅ Multi-row headers
• ☑️ Merged headers — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Merged value headers through mergeValueHeaders
• ☑️ Repeated labels — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Hidden repeated labels — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Compact headers through flatHeaders
• ✅ Sticky headers through RevoGrid
• ☑️ Rotated headers — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Wrapped headers — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.

---

15. Cell Rendering

Value rendering

• ✅ Raw value renderer
• ✅ Formatted value renderer
• ☑️ Currency renderer — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ☑️ Percentage renderer — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ☑️ Date renderer — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ☑️ Boolean renderer — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ☑️ Badge renderer — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ☑️ Icon renderer — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ☑️ Link renderer — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ☑️ Image renderer — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.

Analytical rendering

• ☑️ Data bars through custom renderer — Why partial: foundation exists through custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Sparklines through custom renderer — Why partial: foundation exists through custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Mini line charts through custom renderer — Why partial: foundation exists through custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Mini bar charts through custom renderer — Why partial: foundation exists through custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Mini area charts through custom renderer — Why partial: foundation exists through custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Heatmap cells through custom renderer/cell properties — Why partial: foundation exists through custom renderer/cell properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Progress bars through custom renderer — Why partial: foundation exists through custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Trend arrows through custom renderer — Why partial: foundation exists through custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ KPI indicators through custom renderer — Why partial: foundation exists through custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Status indicators through custom renderer — Why partial: foundation exists through custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

Custom rendering

• ✅ Custom cell renderer
• ✅ Custom header renderer
• ✅ Custom group renderer
• ✅ Custom subtotal renderer
• ✅ Custom grand total renderer
• ✅ Custom empty cell renderer
• ☑️ Custom loading cell renderer — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ✅ Framework component renderer through RevoGrid wrappers
• ✅ Dimension template/parser propagation to generated columns
• ✅ Total label template bypass for row-axis formatters

---

16. Formatting

Number formatting

• ✅ Decimal places through Pivot value formatting presets
• ✅ Thousands separator through Pivot value formatting presets
• ✅ Currency symbol through Pivot value formatting presets
• ✅ Currency code through Pivot value formatting presets
• ✅ Percentage format through Pivot value formatting presets
• ☑️ Scientific notation — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Compact notation — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Negative number format — Why partial: styling hooks exist, but there are no complete Pivot presets, tokens, and documented runtime controls yet.
• ☑️ Zero display format — Why partial: styling hooks exist, but there are no complete Pivot presets, tokens, and documented runtime controls yet.
• ☑️ Null display format — Why partial: styling hooks exist, but there are no complete Pivot presets, tokens, and documented runtime controls yet.

Date formatting

• ✅ Short date through Pivot value formatting presets
• ✅ Long date through Pivot value formatting presets
• ✅ Date-time through Pivot value formatting presets
• ☑️ Time only — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Relative date — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Custom date format — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ✅ Locale-aware date format through Pivot value formatting presets
• ☑️ Timezone-aware date format — Why partial: styling hooks exist, but there are no complete Pivot presets, tokens, and documented runtime controls yet.

Conditional formatting

• ✅ Value-based formatting through conditional formatting presets
• ✅ Measure-based formatting through conditional formatting presets
• ☑️ Field-based formatting through cell properties/templates — Why partial: foundation exists through cell properties/templates, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Row-based formatting through cell properties/templates — Why partial: foundation exists through cell properties/templates, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Column-based formatting through cell properties/templates — Why partial: foundation exists through cell properties/templates, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Group-level formatting through group label templates — Why partial: foundation exists through group label templates, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Subtotal formatting
• ✅ Grand total formatting
• ☑️ Formula-based formatting — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.

---

17. Conditional Formatting Rules

Rule types

• ✅ Greater than through conditional formatting presets
• ✅ Less than through conditional formatting presets
• ✅ Between through conditional formatting presets
• ✅ Equal to through conditional formatting presets
• ✅ Text contains through conditional formatting presets
• ☑️ Date occurs through custom cell properties — Why partial: foundation exists through custom cell properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Duplicate values through custom cell properties — Why partial: foundation exists through custom cell properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Unique values through custom cell properties — Why partial: foundation exists through custom cell properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Top N through custom cell properties — Why partial: foundation exists through custom cell properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Bottom N through custom cell properties — Why partial: foundation exists through custom cell properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Above average through custom cell properties — Why partial: foundation exists through custom cell properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Below average through custom cell properties — Why partial: foundation exists through custom cell properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Formula rule through custom cell properties — Why partial: foundation exists through custom cell properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Custom function rule through custom cell properties — Why partial: foundation exists through custom cell properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

Visual styles

• ✅ Background color through cell properties
• ✅ Text color through cell properties
• ✅ Font weight through cell properties
• ✅ Border through cell properties
• ☑️ Icon set through custom renderer — Why partial: foundation exists through custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Data bar through custom renderer — Why partial: foundation exists through custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Color scale through cell properties — Why partial: foundation exists through cell properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Heatmap through cell properties — Why partial: foundation exists through cell properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Badge through custom renderer — Why partial: foundation exists through custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Tooltip through custom renderer/properties — Why partial: foundation exists through custom renderer/properties, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Cell flash

Rule management

• 🚧 Add rule
• 🚧 Edit rule
• 🚧 Delete rule
• 🚧 Reorder rules
• 🚧 Enable/disable rule
• 🚧 Stop if true
• 🚧 Apply to selected measure
• 🚧 Apply to selected field
• 🚧 Apply to entire pivot

---

18. Drilldown

Cell drilldown

• ✅ Drill into aggregated cell through PivotDrilldownController
• ✅ Show source rows through PivotDrilldownController
• ✅ Show filtered raw records through PivotDrilldownController
• 🚧 Show drilldown panel
• 🚧 Show drilldown modal
• 🚧 Show drilldown table
• 🚧 Export drilldown rows
• 🚧 Copy drilldown rows

Drill path

• ✅ Drill down one level through row/column expand-collapse
• ✅ Drill up one level through row/column expand-collapse
• ☑️ Drill to leaf records through remote drilldown contract — Why partial: foundation exists through remote drilldown contract, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Drill across dimensions — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Drill through to source system through custom remote store — Why partial: foundation exists through to source system through custom remote store, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Breadcrumb navigation — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Preserve drill state for rows and columns

Drilldown permissions

• ☑️ Disable drilldown — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Field-level drilldown permission through field registry — Why partial: foundation exists through field registry, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Measure-level drilldown permission — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ✅ Mask sensitive fields through drilldown visible whitelist
• ✅ Server-side drilldown authorization boundary

---

19. Expand / Collapse

Row expansion

• ✅ Expand row group
• ✅ Collapse row group
• ✅ Expand all rows
• ✅ Collapse all rows
• ✅ Expand selected group
• ✅ Collapse selected group
• ☑️ Expand to row level — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Collapse to row level — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• 🚧 Lazy expand
• 🚧 Async expand

Column expansion

• ✅ Expand column group
• ✅ Collapse column group
• ✅ Expand all columns
• ✅ Collapse all columns
• ✅ Expand selected column group
• ✅ Collapse selected column group
• ☑️ Expand to column level — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Collapse to column level — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• 🚧 Lazy column expand
• 🚧 Async column expand

Expansion state

• ✅ Save expansion state
• ✅ Restore expansion state
• ✅ Serialize expansion state through pivot config
• ✅ Path-based expansion
• ☑️ Key-based expansion — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Server-side expansion state — Why partial: remote/server contracts or hooks exist, but the default backend, UI flow, and end-to-end behavior are not fully shipped.
• ✅ Initial expanded paths
• ✅ Initial collapsed paths
• ✅ Persisted column collapsed state map

---

20. Selection

Cell selection

• ☑️ Single cell selection through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Multiple cell selection through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Range selection through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Non-contiguous selection through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Select visible cells only — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Select raw values — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Select formatted values — Why partial: styling hooks exist, but there are no complete Pivot presets, tokens, and documented runtime controls yet.

Row selection

• ☑️ Select row group through RevoGrid grouping/selection — Why partial: foundation exists through RevoGrid grouping/selection, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Select leaf row through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Select subtotal row through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Select grand total row through RevoGrid pinned rows — Why partial: foundation exists through RevoGrid pinned rows, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Select all visible rows — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• 🚧 Select all source rows behind group
• ☑️ Checkbox selection through RevoGrid/custom columns — Why partial: foundation exists through RevoGrid/custom columns, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Keyboard row selection through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

Column selection

• ☑️ Select pivot column through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Select column group through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Select measure column through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Select subtotal column through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Select grand total column through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Select all visible columns — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Keyboard column selection through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

---

21. Copy / Paste

Copy

• ☑️ Copy selected cells through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Copy with row headers through Pivot TSV copy helper
• ✅ Copy with column headers through Pivot TSV copy helper
• ✅ Copy with full pivot headers through Pivot TSV copy helper
• ☑️ Copy raw values — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Copy formatted values — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ✅ Copy as TSV through Pivot TSV copy helper
• ☑️ Copy as CSV — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Copy as HTML table — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• 🚧 Copy selected drilldown rows

Paste

• ☑️ Paste into source data through RevoGrid editing — Why partial: foundation exists through RevoGrid editing, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Paste into editable cells through RevoGrid editing — Why partial: foundation exists through RevoGrid editing, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Paste range through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Paste with validation through RevoGrid/custom validation — Why partial: foundation exists through RevoGrid/custom validation, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Paste with parsing through RevoGrid parsers — Why partial: foundation exists through RevoGrid parsers, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Paste with type conversion through RevoGrid parsers — Why partial: foundation exists through RevoGrid parsers, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Paste conflict handling
• 🚧 Paste undo support

---

22. Editing

Source editing

• ☑️ Edit source cell through RevoGrid editing — Why partial: foundation exists through RevoGrid editing, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Add source row — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Delete source row — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Update source row — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Batch edit rows — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Validate source edit — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Recalculate pivot after edit — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• 🚧 Highlight affected pivot cells

Pivot editing

• 🚧 Edit aggregated value
• 🚧 Write-back to source records
• 🚧 Distribute value change
• 🚧 Equal distribution
• 🚧 Proportional distribution
• 🚧 Custom distribution strategy
• ☑️ Lock non-editable measures through readonly generated columns/total cells — Why partial: foundation exists through readonly generated columns/total cells, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Edit validation
• 🚧 Edit audit log

Editing UX

• ☑️ Inline editor through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Popup editor through RevoGrid/custom editor — Why partial: foundation exists through RevoGrid/custom editor, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Formula editor
• ☑️ Dropdown editor through RevoGrid/custom editor — Why partial: foundation exists through RevoGrid/custom editor, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Date editor through RevoGrid/custom editor — Why partial: foundation exists through RevoGrid/custom editor, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Number editor through RevoGrid/custom editor — Why partial: foundation exists through RevoGrid/custom editor, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Currency editor through RevoGrid/custom editor — Why partial: foundation exists through RevoGrid/custom editor, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Custom editor through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Commit/cancel edit through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Undo/redo edit

---

23. Undo / Redo

Layout undo

• 🚧 Undo field move
• 🚧 Undo field remove
• 🚧 Undo field add
• 🚧 Undo sort change
• 🚧 Undo filter change
• 🚧 Undo format change
• 🚧 Undo layout reset

Data undo

• 🚧 Undo cell edit
• 🚧 Undo row insert
• 🚧 Undo row delete
• 🚧 Undo paste
• 🚧 Undo batch update
• 🚧 Redo all actions

History

• 🚧 Action history
• 🚧 Transaction grouping
• 🚧 Named transactions
• 🚧 Clear history
• 🚧 History size limit
• 🚧 Server-side history integration

---

24. Export

CSV export

• ✅ Export visible pivot through Pivot CSV export helper
• ☑️ Export full pivot — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Export expanded rows only — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Export all rows — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Export selected range — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• 🚧 Export drilldown rows
• ☑️ Export raw values — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Export formatted values — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.

Excel export

• ☑️ Export to XLSX through external/custom integration — Why partial: foundation exists through external/custom integration, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Export merged headers — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Export grouped headers — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Export subtotals — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Export grand totals — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Export formatting — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Export conditional formatting — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Export frozen panes — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Export column widths — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Export multiple sheets — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• 🚧 Export drilldown sheet

Other export

• ✅ Export to JSON through Pivot state JSON helper
• ✅ Export pivot state through Pivot state JSON helper
• 🚧 Export PDF
• 🚧 Export image
• ☑️ Export clipboard through grid copy support — Why partial: foundation exists through grid copy support, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Server-side export through request contract extension — Why partial: foundation exists through request contract extension, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Background export job

---

25. Import

File import

• ☑️ Import CSV through application/source setup — Why partial: foundation exists through application/source setup, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Import TSV through application/source setup — Why partial: foundation exists through application/source setup, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Import Excel through application/source setup — Why partial: foundation exists through application/source setup, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Import JSON through application/source setup — Why partial: foundation exists through application/source setup, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Import clipboard data through grid paste/source setup — Why partial: foundation exists through grid paste/source setup, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Import from URL through application/source setup — Why partial: foundation exists through application/source setup, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Import from database adapter through remote store/adapter — Why partial: foundation exists through remote store/adapter, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

Import processing

• ☑️ Header detection — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Type inference — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Schema mapping — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Field mapping — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Data validation — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Error reporting — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• 🚧 Preview before import
• ☑️ Import transformation — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• 🚧 Import deduplication

Pivot import

• ☑️ Import pivot state through serializable config — Why partial: foundation exists through serializable config, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Import saved view through remote state API — Why partial: foundation exists through remote state API, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Import calculated fields through precomputed/custom fields — Why partial: foundation exists through precomputed/custom fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Import formatting rules
• ☑️ Import filters through config/grid filter state — Why partial: foundation exists through config/grid filter state, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Import sort rules through grid sort state — Why partial: foundation exists through grid sort state, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

---

26. Charts

Pivot charts

• 🚧 Bar chart
• 🚧 Stacked bar chart
• 🚧 Line chart
• 🚧 Area chart
• 🚧 Pie chart
• 🚧 Donut chart
• 🚧 Scatter chart
• 🚧 Bubble chart
• 🚧 Heatmap
• 🚧 Treemap
• 🚧 Waterfall chart
• 🚧 Combo chart

Chart integration

• ☑️ Generate chart from pivot through external adapter/source data — Why partial: foundation exists through external adapter/source data, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Chart selected range through RevoGrid selection plus external charting — Why partial: foundation exists through RevoGrid selection plus external charting, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Chart selected row group — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Chart selected column group — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Sync chart with filters — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ☑️ Sync chart with pivot state — Why partial: state primitives exist, but complete persistence, management UI, and migration behavior are incomplete.
• 🚧 Drill from chart to pivot
• 🚧 Export chart
• 🚧 Custom chart adapter

---

27. Performance

Rendering performance

• ✅ Row virtualization through RevoGrid
• ✅ Column virtualization through RevoGrid
• ✅ Header virtualization through RevoGrid
• ☑️ Group row virtualization through RevoGrid grouping — Why partial: foundation exists through RevoGrid grouping, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Dynamic column virtualization through RevoGrid
• ✅ Frozen area virtualization through RevoGrid
• ✅ Efficient DOM recycling through RevoGrid
• ☑️ Incremental rendering through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Lazy cell rendering through RevoGrid/custom templates — Why partial: foundation exists through RevoGrid/custom templates, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

Aggregation performance

• ✅ Incremental aggregation for common client aggregators while scanning rows
• ☑️ Memoized aggregation tree — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ ☑️ recalculation — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Dirty path recalculation — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Batch recalculation — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• 🚧 Web Worker aggregation
• 🚧 WASM aggregation support
• ☑️ Async aggregation through remote/server mode — Why partial: foundation exists through remote/server mode, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Streaming aggregation — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.

Large data support

• ☑️ Hundreds of thousands of rows — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Millions of rows with server-side mode contract
• ✅ High column count support through column virtualization/server column viewport
• ☑️ High cardinality field support — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Sparse matrix support through remote cell matrix materialization — Why partial: foundation exists through remote cell matrix materialization, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Memory usage optimization — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Backpressure handling — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Performance diagnostics through remote diagnostics model formatter

---

28. Server-Side Pivot

Server request model

• ✅ Row group descriptors
• ✅ Column group descriptors
• ✅ Value descriptors
• ✅ Filter descriptors
• ✅ Sort descriptors
• ✅ Expanded row paths
• ✅ Expanded column paths
• ✅ Row viewport
• ✅ Column viewport
• ✅ Requested summaries
• ✅ Drilldown request
• ☑️ Export request — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ✅ UI state hints
• ✅ Request id correlation
• ✅ View id and fields version

Server response model

• ✅ Pivot rows
• ✅ Pivot columns through axis paths/materialization
• ✅ Cell matrix through __rowPath and __columnPath
• ☑️ Sparse cell matrix — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Row group count
• ✅ Column group count
• ✅ Total summaries
• ✅ Group summaries
• ✅ Metadata
• ✅ Warnings
• ☑️ Errors through typed PivotError — Why partial: foundation exists through typed PivotError, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Pinned summary rows

Server features

• ✅ Server-side grouping contract
• ✅ Server-side aggregation contract
• ✅ Server-side filtering contract
• ✅ Server-side sorting contract
• ✅ Server-side pagination
• ☑️ Server-side expansion — Why partial: remote/server contracts or hooks exist, but the default backend, UI flow, and end-to-end behavior are not fully shipped.
• ✅ Server-side drilldown contract
• ☑️ Server-side export — Why partial: remote/server contracts or hooks exist, but the default backend, UI flow, and end-to-end behavior are not fully shipped.
• ✅ Server-side cache key contract
• ✅ Query cancellation
• ✅ SQL-oriented query planner
• ✅ Average summary decomposition into sum/count plan
• ✅ Server response normalization helpers

---

29. Caching

Client cache

• ☑️ Raw data cache through captured original source — Why partial: foundation exists through captured original source, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Aggregation cache — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Group tree cache — Why partial: cache keys/state foundations exist, but full lifecycle, invalidation, and observability are not complete.
• ☑️ Column tree cache — Why partial: cache keys/state foundations exist, but full lifecycle, invalidation, and observability are not complete.
• ☑️ Cell value cache — Why partial: cache keys/state foundations exist, but full lifecycle, invalidation, and observability are not complete.
• ☑️ Format cache — Why partial: cache keys/state foundations exist, but full lifecycle, invalidation, and observability are not complete.
• ☑️ Drilldown cache through remote store dedup keys — Why partial: foundation exists through remote store dedup keys, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Expansion cache through pivot config state
• ✅ View state cache through remote state API contract
• ✅ In-flight load deduplication

Server cache

• ✅ Query result cache key generation
• ☑️ Aggregation cache — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Dimension member cache — Why partial: cache keys/state foundations exist, but full lifecycle, invalidation, and observability are not complete.
• ☑️ Filter value cache — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ☑️ Export cache — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Drilldown cache key generation — Why partial: cache keys/state foundations exist, but full lifecycle, invalidation, and observability are not complete.
• ☑️ Cache invalidation request contract — Why partial: remote/server contracts or hooks exist, but the default backend, UI flow, and end-to-end behavior are not fully shipped.
• ☑️ Cache TTL — Why partial: cache keys/state foundations exist, but full lifecycle, invalidation, and observability are not complete.
• ✅ Cache key generation
• ✅ Tenant/view/fields/dataset watermark cache scope
• ✅ Cache status response metadata

---

30. Realtime Updates

Data updates

• ☑️ Insert row through source replacement/reapply — Why partial: foundation exists through source replacement/reapply, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Update row through source replacement/reapply — Why partial: foundation exists through source replacement/reapply, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Delete row through source replacement/reapply — Why partial: foundation exists through source replacement/reapply, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Batch updates through source replacement/reapply — Why partial: foundation exists through source replacement/reapply, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Streaming updates
• 🚧 WebSocket updates
• 🚧 Event-source updates
• ☑️ Polling updates through application-controlled source/remote reload — Why partial: foundation exists through application-controlled source/remote reload, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

Pivot recalculation

• ☑️ Recalculate affected groups — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Recalculate affected measures — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Recalculate affected totals — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Preserve expansion state
• ☑️ Preserve selection — Why partial: base grid behavior exists, but Pivot-specific grouped rows, generated columns, and totals need dedicated UX/accessibility coverage.
• ☑️ Preserve scroll position — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Preserve editing state — Why partial: state primitives exist, but complete persistence, management UI, and migration behavior are incomplete.
• 🚧 Throttle updates
• 🚧 Debounce updates
• ✅ Reapply pivot after external source changes
• ✅ Reapply pivot after external column changes

Visual feedback

• 🚧 Cell flash
• 🚧 Row flash
• 🚧 Updated group indicator
• 🚧 Changed total indicator
• 🚧 Stale data indicator
• ☑️ Last updated timestamp through remote metadata — Why partial: foundation exists through remote metadata, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

---

31. State Management

Pivot state

• ✅ Rows state
• ✅ Columns state
• ✅ Values state
• ✅ Filters state
• ✅ Sorting state
• ☑️ Formatting state through dimension config — Why partial: foundation exists through dimension config, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Expansion state
• ☑️ Selection state through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Scroll state through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Field panel state
• ✅ Column collapse state
• ✅ Engine/view/field-version state

State operations

• ✅ Get state through active config/grid properties
• ✅ Set state through grid.pivot
• ✅ Reset state through clearPivot()/empty config
• ☑️ Merge state through config update event patches — Why partial: foundation exists through config update event patches, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Serialize state through pivot config
• ✅ Deserialize state through pivot config
• ☑️ Version state through remote state response version — Why partial: foundation exists through remote state response version, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Migrate state — Why partial: state primitives exist, but complete persistence, management UI, and migration behavior are incomplete.
• ☑️ Validate state — Why partial: state primitives exist, but complete persistence, management UI, and migration behavior are incomplete.

Saved views

• ✅ Save view through typed remote store helper
• ✅ Load view through typed remote store helper
• ✅ Rename view through saved-view collection helper
• ✅ Delete view through saved-view delete intent helper
• ✅ Duplicate view through saved-view collection helper
• 🚧 Share view
• 🚧 Favorite view
• 🚧 Default view
• ☑️ User view through remote state user id — Why partial: foundation exists through remote state user id, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Team view
• 🚧 Public view

---

32. API

Pivot API

• ✅ setRows through grid.pivot.rows update
• ✅ getRows through grid.pivot.rows/active config
• ✅ setColumns through grid.pivot.columns update
• ✅ getColumns through grid.pivot.columns/active config
• ✅ setValues through grid.pivot.values update
• ✅ getValues through grid.pivot.values/active config
• ✅ setFilters through grid.pivot.filters/remote filters
• ✅ getFilters through grid.pivot.filters/remote filters
• ✅ setSorting through RevoGrid sorting plugin/remote controller
• ✅ getSorting through RevoGrid sorting plugin/remote controller
• ✅ refresh through applyPivot()/config reassignment
• ✅ reset through clearPivot()
• ✅ createPivotData
• ✅ createPivotDataModel
• ✅ pivotColumns
• ✅ pivotColumnsFromPaths

Expansion API

• ✅ expandPath through expanded state updates
• ✅ collapsePath through expanded state updates
• ✅ expandAll through collapsed: false
• ✅ collapseAll through collapsed: true
• ☑️ expandToLevel — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ collapseToLevel — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ getExpandedPaths through config state
• ✅ setExpandedPaths through config state
• ✅ Column collapse state through collapsedColumns

Data API

• ✅ setData through grid source replacement
• ✅ getData through grid source/original source
• ☑️ updateRows — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ appendRows — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ removeRows — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ refreshData through source change/reapply
• ✅ getSourceRows through captured original source
• ☑️ getDrilldownRows through remote drilldown contract — Why partial: foundation exists through remote drilldown contract, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

Export API

• ✅ exportCsv through Pivot CSV export helper
• ☑️ exportExcel — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ✅ exportJson through Pivot state JSON helper
• ✅ exportState through serializable pivot config
• ☑️ exportDrilldown — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.

Remote API

• ✅ PivotEngineAdapter.load
• ✅ PivotEngineAdapter.drilldown
• ✅ PivotRemoteStore.load
• ✅ PivotRemoteStore.drilldown
• ✅ PivotRemoteStore.saveState
• ✅ PivotRemoteStore.loadState
• ✅ HttpPivotRemoteStore
• ✅ SqlPivotQueryPlanner
• ✅ createFieldRegistry
• ✅ createPivotCacheKey

---

33. Events

Layout events

• ✅ Pivot changed through PIVOT_CFG_UPDATE_EVENT
• ✅ Field added through config update event
• ✅ Field removed through config update event
• ✅ Field moved through config update event
• ✅ Field reordered through config update event
• ✅ Rows changed through config update event
• ✅ Columns changed through config update event
• ✅ Values changed through config update event
• ✅ Filters changed through config update event
• ✅ Sorting changed through RevoGrid sorting events/remote sort handling

Interaction events

• ✅ Cell click through RevoGrid
• ✅ Cell double click through RevoGrid
• ✅ Cell context menu through RevoGrid
• ✅ Header click through RevoGrid
• ✅ Group click through RevoGrid grouping
• ✅ Expand through RevoGrid group/column events
• ✅ Collapse through RevoGrid group/column events
• ✅ Selection change through RevoGrid
• 🚧 Drilldown open
• 🚧 Drilldown close
• ✅ Column collapse event integration
• ✅ Column expand event integration

Data events

• ✅ Data loading through loader event in remote mode
• ✅ Data loaded through remote hooks/grid events
• ✅ Data error through remote hooks and Pivot UI diagnostics
• ✅ Data refreshed through source set/reapply
• ☑️ Aggregation started — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Aggregation finished — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ✅ Server request started through remote store hooks
• ✅ Server request finished through remote store hooks
• ✅ Server request failed through remote store hooks
• ✅ Pagination change event integration
• ✅ Filter apply event interception in server mode
• ✅ Sorting apply event interception in server mode

Editing events

• ☑️ Edit start through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Edit validate through RevoGrid/custom validation — Why partial: foundation exists through RevoGrid/custom validation, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Edit commit through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Edit cancel through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Edit error through RevoGrid/custom validation — Why partial: foundation exists through RevoGrid/custom validation, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Paste start through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Paste commit through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Undo
• 🚧 Redo

---

34. Accessibility

Keyboard support

• ☑️ Keyboard navigation through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Keyboard selection through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Keyboard expand/collapse through RevoGrid grouping/headers — Why partial: foundation exists through RevoGrid grouping/headers, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Keyboard field panel control — Why partial: base grid behavior exists, but Pivot-specific grouped rows, generated columns, and totals need dedicated UX/accessibility coverage.
• ☑️ Keyboard sorting through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Keyboard filtering through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Keyboard editing through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Keyboard shortcuts — Why partial: base grid behavior exists, but Pivot-specific grouped rows, generated columns, and totals need dedicated UX/accessibility coverage.

Screen reader support

• ☑️ ARIA grid roles through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ ARIA row groups through RevoGrid grouping — Why partial: foundation exists through RevoGrid grouping, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ ARIA column groups through RevoGrid headers — Why partial: foundation exists through RevoGrid headers, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ ARIA expanded state — Why partial: base grid behavior exists, but Pivot-specific grouped rows, generated columns, and totals need dedicated UX/accessibility coverage.
• ☑️ ARIA selected state — Why partial: base grid behavior exists, but Pivot-specific grouped rows, generated columns, and totals need dedicated UX/accessibility coverage.
• ☑️ ARIA sort state — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ☑️ Accessible labels — Why partial: base grid behavior exists, but Pivot-specific grouped rows, generated columns, and totals need dedicated UX/accessibility coverage.
• ☑️ Accessible descriptions — Why partial: base grid behavior exists, but Pivot-specific grouped rows, generated columns, and totals need dedicated UX/accessibility coverage.

Visual accessibility

• ☑️ High contrast mode through theming — Why partial: foundation exists through theming, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Reduced motion mode through CSS/application theme — Why partial: foundation exists through CSS/application theme, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Focus outlines through RevoGrid/browser controls
• ☑️ Large touch targets — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Color-blind-safe formatting — Why partial: styling hooks exist, but there are no complete Pivot presets, tokens, and documented runtime controls yet.
• ☑️ Text alternatives for icons — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.

---

35. Permissions

Field permissions

• ☑️ Hide field through dimensions/field registry — Why partial: foundation exists through dimensions/field registry, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Disable field through dimensions/field registry — Why partial: foundation exists through dimensions/field registry, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Read-only field through RevoGrid readonly columns — Why partial: foundation exists through RevoGrid readonly columns, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ No-export field — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ✅ No-drilldown field through registry drilldownVisible
• ☑️ Masked field through backend/custom renderer — Why partial: foundation exists through backend/custom renderer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Aggregated-only field through remote field registry policy — Why partial: foundation exists through remote field registry policy, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

Action permissions

• ☑️ Disable export — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Disable drilldown — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Disable editing through readonly columns — Why partial: foundation exists through readonly columns, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Disable field panel through config
• 🚧 Disable calculated fields
• 🚧 Disable custom formulas
• ☑️ Disable saved views through store/policy — Why partial: foundation exists through store/policy, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Disable sharing

Data permissions

• ☑️ Row-level security through server-side backend — Why partial: foundation exists through server-side backend, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Column-level security through field registry/backend — Why partial: foundation exists through field registry/backend, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Measure-level security through allowed summaries/backend — Why partial: foundation exists through allowed summaries/backend, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Drilldown-level security through field registry/backend authorization boundary
• ✅ Server-side permission validation helpers
• ☑️ Permission-aware totals — Why partial: backend/custom hooks can enforce it, but Pivot does not yet ship complete policy configuration, UI, and audit flows.
• ☑️ Permission-aware filters — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.

---

36. Security

Client security

• 🚧 Safe formula execution
• ✅ No unsafe eval in pivot implementation
• ☑️ Sanitized renderers — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ☑️ XSS-safe cell content through RevoGrid/default rendering — Why partial: foundation exists through RevoGrid/default rendering, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ XSS-safe tooltips — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ XSS-safe exports — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ☑️ Safe custom HTML mode — Why partial: extension points can support it, but Pivot does not yet provide built-in presets, configuration UI, and documented behavior.
• ☑️ CSP compatibility — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.

Server security

• ✅ Validate pivot requests through field registry/planner helpers
• ✅ Validate filter expressions through allowed operations metadata
• ✅ Validate sort expressions through selector registry
• ☑️ Validate calculated fields — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Rate limit expensive queries — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Query timeout/cancellation through AbortSignal contract
• ✅ Request size limit through PivotLimits contract
• ✅ Export size limit through PivotLimits contract
• ☑️ Audit logging through remote hooks/backend — Why partial: foundation exists through remote hooks/backend, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Typed pivot errors

---

37. Observability

Performance metrics

• ☑️ Render time through external instrumentation — Why partial: foundation exists through external instrumentation, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Aggregation time through remote metadata — Why partial: foundation exists through remote metadata, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Filter time through remote metadata — Why partial: foundation exists through remote metadata, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Sort time through remote metadata — Why partial: foundation exists through remote metadata, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Export time — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ✅ Server request time through remote metadata/hooks
• ✅ Cache hit rate through cache status metadata/hooks
• ☑️ Memory usage — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Visible row count through response row-axis metadata
• ✅ Visible column count through response column-axis metadata
• ✅ Generated timestamp metadata
• ✅ Request correlation id

Debugging

• ☑️ Debug mode — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Query inspector through planner/request objects — Why partial: foundation exists through planner/request objects, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Pivot state inspector through serializable config
• ✅ Field metadata inspector through field registry
• ☑️ Aggregation tree inspector — Why partial: aggregation/custom-field foundations exist, but this needs a first-class Pivot API, UI, dependency handling, and tests.
• ☑️ Render profiler — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Slow operation warnings through response warnings metadata
• ✅ Error details through PivotError metadata
• ✅ Developer warnings through console errors/typed errors
• ✅ Remote warnings and errors in Pivot UI diagnostics

---

38. Theming

Theme support

• ✅ Light theme through RevoGrid theme/CSS
• ✅ Dark theme through RevoGrid theme/CSS
• ☑️ High contrast theme — Why partial: styling hooks exist, but there are no complete Pivot presets, tokens, and documented runtime controls yet.
• ☑️ Compact theme — Why partial: styling hooks exist, but there are no complete Pivot presets, tokens, and documented runtime controls yet.
• ✅ Custom theme through CSS/classes
• ✅ CSS variables through RevoGrid/plugin styles
• ☑️ Theme tokens — Why partial: styling hooks exist, but there are no complete Pivot presets, tokens, and documented runtime controls yet.
• ✅ Runtime theme switching
• ✅ Theme propagation to configurator and field panel

Style customization

• ✅ Cell styles through RevoGrid cell properties
• ✅ Header styles through RevoGrid column config
• ✅ Group row styles through grouping template/CSS
• ✅ Subtotal styles
• ✅ Grand total styles
• ✅ Field panel styles
• ☑️ Filter popup styles through RevoGrid — Why partial: foundation exists through RevoGrid, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Drag-and-drop styles

---

39. Localization

Text localization

• ✅ Field panel labels
• ☑️ Filter labels through RevoGrid/application — Why partial: foundation exists through RevoGrid/application, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Sort labels through RevoGrid/application — Why partial: foundation exists through RevoGrid/application, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Aggregation labels through configurator/value selector text
• ✅ Empty states in field/configurator panels
• ☑️ Error messages — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• 🚧 Export labels
• ☑️ Context menu labels through RevoGrid/application — Why partial: foundation exists through RevoGrid/application, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Configurator labels through i18n

Locale formatting

• ✅ Locale number formatting through Pivot value formatting presets
• ✅ Locale currency formatting through Pivot value formatting presets
• ✅ Locale date formatting through Pivot value formatting presets
• ☑️ Locale time formatting through custom templates/parsers — Why partial: foundation exists through custom templates/parsers, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Locale sorting through custom comparators — Why partial: foundation exists through custom comparators, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ RTL layout support — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Timezone support through custom templates/parsers — Why partial: foundation exists through custom templates/parsers, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

---

40. Framework Integration

JavaScript

• ✅ Vanilla JS support
• ✅ TypeScript support
• ✅ ESM build
• ☑️ CJS build — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Tree-shakable modules
• ✅ Public TypeScript exports for client, remote, field registry, cache, planner, and engine APIs

Frameworks

• ✅ React wrapper/examples
• ✅ Vue wrapper/examples
• ✅ Angular wrapper/examples
• ☑️ Svelte wrapper through Web Component usage — Why partial: foundation exists through Web Component usage, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Solid wrapper through Web Component usage — Why partial: foundation exists through Web Component usage, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Web Components support

Integration helpers

• ☑️ Controlled state mode through grid.pivot and update events — Why partial: foundation exists through grid.pivot and update events, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Uncontrolled state mode through plugin-owned active config
• ☑️ React hooks — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Vue composables — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ Angular services — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Event adapters through RevoGrid custom events
• ✅ Type-safe config

---

41. Documentation

User docs

• ✅ Basic pivot guide/demo
• ✅ Field panel guide/demo
• ✅ Aggregation guide/demo through custom aggregator examples
• ☑️ Filtering guide — Why partial: filter state and mapping exist, but this specific Pivot filter mode lacks dedicated UI, semantics, and validation.
• ☑️ Sorting guide — Why partial: sorting foundations exist, but this specific Pivot sort mode lacks dedicated controls, semantics, and coverage.
• ✅ Formatting guide/demo
• ☑️ Export guide — Why partial: grid/application hooks can support it, but Pivot-specific header/state/value handling is not complete.
• ✅ Drilldown guide/demo for expand-collapse
• ☑️ Saved views guide — Why partial: some examples or APIs exist, but documentation is not complete enough to treat it as shipped.
• ✅ Totals guide/demo
• ✅ Remote pivot guide/demo
• ✅ Values-on-rows guide/demo

Developer docs

• ☑️ API reference — Why partial: some examples or APIs exist, but documentation is not complete enough to treat it as shipped.
• ☑️ Type reference — Why partial: some examples or APIs exist, but documentation is not complete enough to treat it as shipped.
• ✅ Custom aggregation guide/demo
• ✅ Custom renderer guide through RevoGrid examples
• ✅ Server-side pivot guide/demo
• ☑️ Data adapter guide — Why partial: some examples or APIs exist, but documentation is not complete enough to treat it as shipped.
• ☑️ Performance guide — Why partial: some examples or APIs exist, but documentation is not complete enough to treat it as shipped.
• ☑️ Security guide — Why partial: backend/custom hooks can enforce it, but Pivot does not yet ship complete policy configuration, UI, and audit flows.
• ☑️ Migration guide — Why partial: some examples or APIs exist, but documentation is not complete enough to treat it as shipped.

Examples

• ✅ Basic pivot
• ✅ Sales analytics
• ☑️ Finance report — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ ERP inventory — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ✅ Server-side pivot
• 🚧 Realtime pivot
• ☑️ Editable pivot — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• 🚧 Pivot with charts
• ☑️ Pivot with permissions — Why partial: backend/custom hooks can enforce it, but Pivot does not yet ship complete policy configuration, UI, and audit flows.
• ☑️ Pivot with saved views — Why partial: state primitives exist, but complete persistence, management UI, and migration behavior are incomplete.
• ✅ Pivot totals
• ✅ Pivot drill-down
• ✅ Pivot values on rows
• ✅ Pivot field panel
• ✅ Pivot custom aggregator
• ✅ Pivot remote/OLAP backend demos

---

42. AI Features

Natural language pivot

• 🚧 Create pivot from prompt
• 🚧 Modify pivot from prompt
• 🚧 Add measure from prompt
• 🚧 Add filter from prompt
• 🚧 Add calculated field from prompt
• 🚧 Explain current pivot
• 🚧 Suggest better pivot
• 🚧 Detect anomalies
• 🚧 Summarize insights

AI assistant actions

• 🚧 Generate pivot layout
• 🚧 Generate chart
• 🚧 Generate formula
• 🚧 Generate aggregation
• 🚧 Generate export summary
• 🚧 Explain drilldown result
• 🚧 Recommend filters
• 🚧 Recommend dimensions

---

43. Enterprise Features

Governance

• ☑️ Shared reports through remote saved-state contract — Why partial: foundation exists through remote saved-state contract, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Team views
• ☑️ Role-based access through backend/field registry — Why partial: foundation exists through backend/field registry, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Audit logs through remote hooks/backend — Why partial: foundation exists through remote hooks/backend, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Change history
• ☑️ Admin-controlled defaults through supplied config — Why partial: foundation exists through supplied config, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Locked reports through backend/application policy — Why partial: foundation exists through backend/application policy, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Certified datasets through viewId/fieldsVersion — Why partial: foundation exists through viewId/fieldsVersion, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

Compliance

• ☑️ Export audit log through backend hooks — Why partial: foundation exists through backend hooks, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Drilldown audit log through backend hooks — Why partial: foundation exists through backend hooks, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Permission audit through backend/field registry — Why partial: foundation exists through backend/field registry, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Data masking through backend/custom renderers — Why partial: foundation exists through backend/custom renderers, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ PII protection through backend/field registry — Why partial: foundation exists through backend/field registry, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Secure formula mode
• ✅ Server validation helpers
• ☑️ Compliance documentation — Why partial: some examples or APIs exist, but documentation is not complete enough to treat it as shipped.

Supportability

• ☑️ Diagnostics package through state/metadata export — Why partial: foundation exists through state/metadata export, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ Error reporting hooks through remote store hooks
• ☑️ Performance report through remote metadata/hooks — Why partial: foundation exists through remote metadata/hooks, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ✅ State snapshot export through serializable config
• ✅ Reproducible bug state through config/source examples
• ☑️ Version compatibility checks through fieldsVersion/response version — Why partial: foundation exists through fieldsVersion/response version, but there is no complete Pivot-specific product workflow, public API, and coverage yet.

---

44. Nice-to-Have Advanced Features

• 🚧 Pivot recommendations
• ☑️ Auto-detected measures through schema/type inference in application layer — Why partial: foundation exists through schema/type inference in application layer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Auto-detected dimensions through schema/type inference in application layer — Why partial: foundation exists through schema/type inference in application layer, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Smart field categorization
• ☑️ Automatic date hierarchy through remote group intervals/application preprocessing — Why partial: foundation exists through remote group intervals/application preprocessing, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Automatic number bucketing through remote numeric buckets/application preprocessing — Why partial: foundation exists through remote numeric buckets/application preprocessing, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Custom hierarchies through row/column dimensions and rowTree — Why partial: foundation exists through row/column dimensions and rowTree, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ Parent-child dimensions through precomputed hierarchy fields — Why partial: foundation exists through precomputed hierarchy fields, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Slowly changing dimensions
• 🚧 Scenario comparison
• 🚧 Budget vs actual mode
• 🚧 Forecast columns
• 🚧 What-if analysis
• 🚧 Editable planning mode
• 🚧 Comments on cells
• 🚧 Cell annotations
• 🚧 Collaborative views
• 🚧 Live cursors
• 🚧 Report subscriptions
• 🚧 Scheduled exports
• 🚧 Email reports
• ☑️ Embedded dashboard mode through Web Component/framework wrappers — Why partial: foundation exists through Web Component/framework wrappers, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ White-label mode through CSS/theming — Why partial: foundation exists through CSS/theming, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 Plugin marketplace
• ✅ Custom pivot extensions through adapters, stores, templates, and aggregators
• ☑️ MCP/AI-agent integration — Why partial: supporting primitives exist, but dedicated Pivot product behavior, public API, UI, and test coverage are incomplete.
• ☑️ OLAP cube adapter through PivotEngineAdapter — Why partial: foundation exists through PivotEngineAdapter, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• ☑️ SQL adapter through SqlPivotQueryPlanner — Why partial: foundation exists through SqlPivotQueryPlanner, but there is no complete Pivot-specific product workflow, public API, and coverage yet.
• 🚧 DuckDB adapter
• 🚧 Apache Arrow support
• 🚧 Parquet support
• 🚧 WASM query engine
• 🚧 Worker-thread query engine