Create advanced Excel pivot tables with calculated fields and slicers. Use when building data summaries or creating interactive dashboards. Trigger with phrases like 'excel pivot', 'create pivot table', 'data summary'.
Creates advanced pivot tables with calculated fields, slicers, and dynamic dashboards for data analysis and reporting.
| Error | Cause | Solution |
|---|---|---|
| Field not found | Changed source data | Refresh data connection |
| Calculated field error | Invalid formula | Check field names match exactly |
| Slicer not updating | Disconnected report | Reconnect slicer to pivot |
Example: Sales Dashboard Request: "Create a pivot summarizing sales by region and product" Result: Pivot with region rows, product columns, revenue values, and date slicer
Example: Financial Analysis Request: "Build a pivot showing monthly trends by cost center" Result: Time-series pivot with calculated YoY growth fields
${CLAUDE_SKILL_DIR}/references/pivot-formulas.md for calculated field syntax43:["$","$L4c",null,{"content":"$4d","frontMatter":{"name":"excel-pivot-wizard","description":"Create advanced Excel pivot tables with calculated fields and slicers.\nUse when building data summaries or creating interactive dashboards.\nTrigger with phrases like 'excel pivot', 'create pivot table', 'data summary'.\n","allowed-tools":"Read, Write, Edit, Grep, Glob, Bash(cmd:*)","version":"1.0.0","author":"Jeremy Longshore [email protected]","license":"MIT","compatible-with":"claude-code, codex, openclaw"}}]