Data Tools

Data Pivot

Create pivot tables and cross-tabulations with custom aggregations and groupings

Input data (JSON array)

Upload

Field name

Value field

Aggregation

Row fields

None added

Column fields

None added

Value fields

None added

Pivot result

Output will appear here...

Example input

[
  { "region": "North", "product": "Laptop", "category": "Electronics", "sales": 1200, "units": 5, "quarter": "Q1" },
  { "region": "South", "product": "Phone", "category": "Electronics", "sales": 800, "units": 10, "quarter": "Q1" },
  { "region": "North", "product": "Book", "category": "Books", "sales": 150, "units": 15, "quarter": "Q2" }
]

Rows: region, category
Columns: quarter
Values: sales (sum), units (average)