Data Pivot

Input Data (JSON Array)

Pivot Configuration

Row Fields:

No row fields added

Column Fields:

No column fields added

Value Fields:

No value fields added

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"
  }
]

Example Pivot:

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