What is pivot analysis
Pivot analysis groups raw records by row and column dimensions, then applies aggregation on numeric fields to produce compact and readable summaries.
How to use
- Choose CSV or JSON input mode.
- Paste data or import a local file.
- Select row, column, and value fields.
- Choose an aggregation type (sum, count, average, max, min).
- Review the pivot table and summary metrics, then export CSV if needed.
Key features
- Supports both CSV and JSON input.
- Supports row-column grouped analysis.
- Includes five common aggregation methods.
- Calculates summary metrics automatically.
- Exports pivot results to CSV.
Use cases
- Sales review by region or product.
- Operations report consolidation.
- Finance reconciliation and grouped totals.
- Classroom exercises and data analysis demos.
FAQ
- Why is the pivot table empty?
Usually because row/value fields are not selected, or input data is empty.
- What happens if value fields contain non-numeric text?
Non-numeric values are treated as 0 in numeric aggregation, while count mode still counts rows.
- Is my data uploaded?
No. All computations run locally in your browser.