Elysia Tools Docs
EN
Language
ZHESPTRUFRDEEN
Back to site
Browse tools

Data Processing

Data Crosstab Generator

Advanced crosstab (pivot table) generator that creates powerful cross-tabulation analysis from your data. Perfect for business intelligence, statistical analysis, data exploration, and reporting. Features: - Multiple aggregation functions (sum, count, average, min, max, median) - Flexible row and column grouping - Percentage and ratio calculations - Row/column totals and grand totals - Multi-dimensional analysis - Conditional formatting support - Statistical significance testing - Custom sorting and filtering - Export-ready formatting Common Use Cases: - Sales analysis by region and product - Customer demographics analysis - Financial statement analysis - Survey response analysis - Inventory turnover analysis - Performance metrics tracking

text· Text resultOpen tool

Quick start

Call this tool from your code in three languages.

cURL
curl -X POST 'https://api.elysiatools.com/en/api/tools/data-crosstab-generator' \
  -H 'Content-Type: application/json' \
  -d '{"inputData":"region,product,sales,quantity,date\nNorth,Laptop,1500,5,2024-01-15\nSouth,Phone,800,10,2024-01-16\nEast,Tablet,600,8,2024-01-17","rowDimension":"region","columnDimension":"product","valueColumn":"sales","aggregateFunction":"sum","includeRowTotals":true,"includeColumnTotals":true,"includeGrandTotal":true,"showPercentages":false,"percentageType":"row","sortByRows":false,"sortByColumns":false,"sortOrder":"asc","numberFormat":",.2f","roundDecimals":2,"emptyCellValue":"-","fillEmptyCells":true,"includeHeaders":true,"headerStyle":"simple","maxColumnWidth":15,"conditionalFormatting":false,"outputFormat":"csv","includeStatistics":false}'

© 2026 Elysia Tools. Developer documentation.

Back to siteBrowse tools

API reference

Send a POST request with your inputs as JSON. File parameters require a separate upload first.

Endpoint

HTTP
POST https://api.elysiatools.com/en/api/tools/data-crosstab-generator

Parameters

NameTypeRequiredDescription
inputDatatextareaYes—
rowDimensiontextYesColumn to use for rows in the crosstab
columnDimensiontextYesColumn to use for columns in the crosstab
valueColumntextYesColumn containing values to aggregate
aggregateFunctionselectNo—
includeRowTotalscheckboxNo—
includeColumnTotalscheckboxNo—
includeGrandTotalcheckboxNo—
showPercentagescheckboxNoDisplay percentage values alongside actual values
percentageTypeselectNo—
sortByRowscheckboxNo—
sortByColumnscheckboxNo—
sortOrderselectNo—
numberFormattextNoNumber formatting (e.g., ",.2f" for 1,234.56, ".0f" for 1235)
roundDecimalsnumberNo—
emptyCellValuetextNoValue to display in empty cells
fillEmptyCellscheckboxNoReplace empty cells with specified value
includeHeaderscheckboxNo—
headerStyleselectNo—
maxColumnWidthnumberNoMaximum width for each column in characters
conditionalFormattingcheckboxNoAdd color coding for high/medium/low values
outputFormatselectNo—
includeStatisticscheckboxNoPrepend analysis header and summary statistics to the output

Response format

Text result

JSON
{
  "result": "Processed text content",
  "error": "Error message (optional)",
  "message": "Notification message (optional)",
  "metadata": {
    "key": "value"
  }
}

MCP integration

Add this tool to your Model Context Protocol server so AI agents can list and call it.

Server configuration

Add this block to your MCP client configuration:

mcp.json
{
  "mcpServers": {
    "elysiatools-data-crosstab-generator": {
      "name": "data-crosstab-generator",
      "description": "Advanced crosstab (pivot table) generator that creates powerful cross-tabulation analysis from your data. Perfect for business intelligence, statistical analysis, data exploration, and reporting.\n\nFeatures:\n- Multiple aggregation functions (sum, count, average, min, max, median)\n- Flexible row and column grouping\n- Percentage and ratio calculations\n- Row/column totals and grand totals\n- Multi-dimensional analysis\n- Conditional formatting support\n- Statistical significance testing\n- Custom sorting and filtering\n- Export-ready formatting\n\nCommon Use Cases:\n- Sales analysis by region and product\n- Customer demographics analysis\n- Financial statement analysis\n- Survey response analysis\n- Inventory turnover analysis\n- Performance metrics tracking",
      "baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=data-crosstab-generator",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

List available tools

After connecting to the SSE endpoint, list the exposed tools:

tools/list
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/list"
}

Call this tool

Invoke the tool by its id, passing arguments built from its parameters:

tools/call
{
  "jsonrpc": "2.0",
  "id": 2,
  "method": "tools/call",
  "params": {
    "name": "data-crosstab-generator",
    "arguments": {
  "inputData": "region,product,sales,quantity,date\nNorth,Laptop,1500,5,2024-01-15\nSouth,Phone,800,10,2024-01-16\nEast,Tablet,600,8,2024-01-17",
  "rowDimension": "region",
  "columnDimension": "product",
  "valueColumn": "sales",
  "aggregateFunction": "sum",
  "includeRowTotals": true,
  "includeColumnTotals": true,
  "includeGrandTotal": true,
  "showPercentages": false,
  "percentageType": "row",
  "sortByRows": false,
  "sortByColumns": false,
  "sortOrder": "asc",
  "numberFormat": ",.2f",
  "roundDecimals": 2,
  "emptyCellValue": "-",
  "fillEmptyCells": true,
  "includeHeaders": true,
  "headerStyle": "simple",
  "maxColumnWidth": 15,
  "conditionalFormatting": false,
  "outputFormat": "csv",
  "includeStatistics": false
}
  }
}
Chain multiple tools in one session with a comma-separated toolId list, e.g. /mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp (max 20).

Questions or issues? Contact [email protected]

Browse tools
Open tool