excel-pivot-wizard
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseExcel Pivot Wizard
Excel数据透视表向导
Overview
概述
Creates advanced pivot tables with calculated fields, slicers, and dynamic dashboards for data analysis and reporting.
创建带有计算字段、切片器和动态仪表板的高级数据透视表，用于数据分析和报表生成。
Prerequisites
前提条件
- Excel or compatible spreadsheet software
- Tabular data with headers
- Clear understanding of analysis dimensions and measures
- Excel或兼容的电子表格软件
- 带表头的表格型数据
- 清晰了解分析维度和度量指标
Instructions
操作步骤
- Verify source data is in tabular format with headers
- Create pivot table from data range
- Configure rows, columns, values, and filters
- Add calculated fields for custom metrics
- Insert slicers for interactive filtering
- Format and style for presentation
- 验证源数据为带表头的表格格式
- 从数据区域创建数据透视表
- 配置行、列、值和筛选器
- 添加计算字段以实现自定义指标
- 插入切片器进行交互式筛选
- 设置格式和样式以适配展示需求
Output
输出结果
- Configured pivot table with appropriate aggregations
- Calculated fields for derived metrics
- Interactive slicers for filtering
- Dashboard-ready formatting
- 配置好的带有合适聚合方式的数据透视表
- 用于衍生指标的计算字段
- 用于筛选的交互式切片器
- 可直接用于仪表板的格式设置
Error Handling
错误处理
| 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 |
| 错误 | 原因 | 解决方案 |
|---|---|---|
| 字段未找到 | 源数据已更改 | 刷新数据连接 |
| 计算字段错误 | 公式无效 | 检查字段名称是否完全匹配 |
| 切片器未更新 | 报表连接断开 | 重新连接切片器与数据透视表 |
Examples
示例
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
示例：销售仪表板
请求："创建按地区和产品汇总销售额的数据透视表"
结果：包含地区行、产品列、收入值和日期切片器的数据透视表
示例：财务分析
请求："构建按成本中心展示月度趋势的数据透视表"
结果：带有同比增长率计算字段的时间序列数据透视表
Resources
参考资源
- Microsoft Pivot Table Guide
- for calculated field syntax
{baseDir}/references/pivot-formulas.md
- Microsoft数据透视表指南
- 提供计算字段语法说明
{baseDir}/references/pivot-formulas.md