Categories

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

Column to use for rows in the crosstab

Column to use for columns in the crosstab

Column containing values to aggregate

Display percentage values alongside actual values

Number formatting (e.g., ",.2f" for 1,234.56, ".0f" for 1235)

Value to display in empty cells

Replace empty cells with specified value

Maximum width for each column in characters

Add color coding for high/medium/low values

API Documentation

Request Endpoint

POST /en/api/tools/data-crosstab-generator

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"
  }
}
Text: Text

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]