Data Processing
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
Call this tool from your code in three languages.
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}'Send a POST request with your inputs as JSON. File parameters require a separate upload first.
POST https://api.elysiatools.com/en/api/tools/data-crosstab-generator| Name | Type | Required | Description |
|---|---|---|---|
| inputData | textarea | Yes | — |
| rowDimension | text | Yes | Column to use for rows in the crosstab |
| columnDimension | text | Yes | Column to use for columns in the crosstab |
| valueColumn | text | Yes | Column containing values to aggregate |
| aggregateFunction | select | No | — |
| includeRowTotals | checkbox | No | — |
| includeColumnTotals | checkbox | No | — |
| includeGrandTotal | checkbox | No | — |
| showPercentages | checkbox | No | Display percentage values alongside actual values |
| percentageType | select | No | — |
| sortByRows | checkbox | No | — |
| sortByColumns | checkbox | No | — |
| sortOrder | select | No | — |
| numberFormat | text | No | Number formatting (e.g., ",.2f" for 1,234.56, ".0f" for 1235) |
| roundDecimals | number | No | — |
| emptyCellValue | text | No | Value to display in empty cells |
| fillEmptyCells | checkbox | No | Replace empty cells with specified value |
| includeHeaders | checkbox | No | — |
| headerStyle | select | No | — |
| maxColumnWidth | number | No | Maximum width for each column in characters |
| conditionalFormatting | checkbox | No | Add color coding for high/medium/low values |
Text result
{
"result": "Processed text content",
"error": "Error message (optional)",
"message": "Notification message (optional)",
"metadata": {
"key": "value"
}
}Add this tool to your Model Context Protocol server so AI agents can list and call it.
Add this block to your MCP client configuration:
{
"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"
}
}
}After connecting to the SSE endpoint, list the exposed tools:
{
"jsonrpc": "2.0",
"id": 1,
"method": "tools/list"
}Invoke the tool by its id, passing arguments built from its parameters:
{
"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
}
}
}Questions or issues? Contact [email protected]