Release v0.3.0

Release v0.3.0

Release v0.2.0

🎈 Version 0.2.0

Release date: April 14, 2026

pip install --upgrade streamlit-pivot

🎉 Highlights

• Faster pivot setup with a redesigned settings panel, drag-and-drop field arrangement, and field search.
• Better time-based analysis with adaptive date grouping and hierarchical date headers on rows and columns.
• More capable drill-down with pagination, sorting, and report-level prefilters.
• Richer exports to Excel, CSV, TSV, and the clipboard, with Excel preserving layout and formatting.
• Improved performance for large, wide, and high-cardinality datasets.

📋 Configuration and interaction

• A new settings panel brings field selection, aggregation, display options, and other pivot controls into a single workflow.
• Drag-and-drop support makes it easier to move and reorder fields across rows, columns, and values.
• Field search helps users work with large schemas more efficiently.
• Fullscreen mode provides a more focused analysis experience.
• Column resizing gives users better control over dense tables.

📊 Analysis features

• Drill-down now supports pagination and sorting for easier record inspection.
• Sorting is applied before pagination so drill-down results stay ordered across pages.
• Report-level prefilters let users narrow data before pivoting.
• More aggregate functions are available for larger-table workflows.

📆 Date and time intelligence

• Typed date and datetime fields now support richer time-based analysis.
• Default date grains adapt to the span of the underlying data.
• Hierarchical date headers support expand and collapse on both axes.

💅 Export and formatting

• Excel export now preserves totals, merged headers, frozen panes, number formats, and conditional formatting.
• DataFrame formatting now carries through more consistently in rendered output and exports.

🏃‍♀️ Performance and reliability

• Frontend parsing and rendering are more efficient, including an improved columnar Arrow path.
• Wide and high-cardinality tables now perform more smoothly.

Release v0.1.0

🎈 Version 0.1.0

Release date: March 30, 2026

pip install --upgrade streamlit-pivot

Highlights

• Launch streamlit-pivot with interactive, multi-dimensional pivot tables for Streamlit apps.
• Explore data with interactive sorting and filtering, collapsible subtotals, column group expand/collapse, and drill-down detail panels.
• Configure measures with per-measure aggregation, synthetic measures, Show Values As, and conditional formatting.
• Export pivot results to CSV, TSV, or the clipboard, with support for formatted or raw output.
• Share viewer-friendly tables with locked mode and non-interactive mode.

Configuration and interaction

• The interactive toolbar makes it possible to choose rows, columns, and values directly in the component.
• Utility actions support resetting the view, swapping rows and columns, copying the active config, and importing saved configs.
• Locked mode keeps authoring controls read-only while preserving exploration features such as sorting, filtering, drill-down, and export.
• Non-interactive mode hides configuration controls for fully read-only displays.

Analysis features

• Per-measure aggregation supports core summary operations including sum, average, count, min, max, distinct count, median, percentile, first, and last.
• Synthetic measures make it possible to define derived metrics such as ratio-of-sums and differences alongside raw measures.
• Show Values As supports percentage-based views for common comparisons.
• Row and column sorting can be driven by keys or aggregated values, including scoped sorting in hierarchical row groupings.
• Drill-down panels reveal the source records behind any data or total cell.

Layout and presentation

• Subtotals support grouped row hierarchies with collapse and expand controls.
• Column groups can be collapsed into subtotal columns for more compact views.
• Number formatting, alignment controls, sticky headers, repeated row labels, and null handling provide more control over table presentation.
• Conditional formatting supports color scales, data bars, and threshold-based highlighting.

Export and integration

• Export options include CSV, TSV, and clipboard output, with a choice between formatted display values and raw values.
• Config state and cell click payloads are exposed through Streamlit session state callbacks, making it easier to integrate the component into larger apps.