excel-pivot-wizard

Creates advanced pivot tables with calculated fields, slicers, and dynamic dashboards for data analysis and reporting.

| 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

使用計算欄位和切片器建立進階 Excel 資料透視表。 在建立資料摘要或建立互動式儀表板時使用。 使用「excel 資料透視表」、「建立資料透視表」、「資料摘要」等短語觸發。 來源：jst-well-dan/skill-box。