Creates pivot table configurations from your data structure
Help me create a pivot table.
Platform: {platform} (Excel / Google Sheets / Python pandas)
Source data: {data}
Columns: {columns}
What needs to be analyzed: {analysis}
Provide:
1. **Pivot table setup**:
- Rows (what to group by)
- Columns (what to compare)
- Values (aggregations: sum, average, count)
- Filters
2. **Step-by-step instructions** for {platform}
3. **Formulas** / Code (if pandas):
- pivot_table or groupby
- Calculated fields (share, growth, deviation)
4. **Visualization**: which chart to build from the pivot table
5. **Insights**: what questions this pivot table can answer
6. **Additional slices**: what other groupings would be useful
0 copies
Variables
Replace these variables with your own values before using:
AI Tools