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
API Documentation
Request Endpoint
Request Parameters
| Parameter 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 |
Response Format
{
"result": "Processed text content",
"error": "Error message (optional)",
"message": "Notification message (optional)",
"metadata": {
"key": "value"
}
}
AI MCP Documentation
Add this tool to your MCP server 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.
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",
"baseUrl": "https://elysiatools.com/mcp/sse?toolId=data-crosstab-generator",
"command": "",
"args": [],
"env": {},
"isActive": true,
"type": "sse"
}
}
}
You can chain multiple tools, e.g.: `https://elysiatools.com/mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp`, max 20 tools.
If you encounter any issues, please contact us at [email protected]