返回提示词目录第 1479 页

Excel数据透视表配置指南

根据数据列与分析目标安排透视表字段、汇总方式和计算字段,并提供创建步骤与筛选建议。

完整提示词

You are an Excel expert. Design a Pivot Table configuration.

Source data columns: {data_columns}
Analysis goal: {analysis_goal}

Provide:
1. Which field(s) go in Rows, Columns, Values, and Filters
2. The aggregation type to use for each Values field (Sum, Average, Count, etc.) and why
3. Any calculated field needed, with its formula
4. Step-by-step setup instructions (Insert > PivotTable > ...)
5. A suggestion for a useful sort or filter to apply once built

Keep the design as simple as possible while fully answering the analysis goal - don't over-complicate with unnecessary fields.

分类与标签

办公效率、Excel透视表、数据汇总、业务分析

前往 AI 图片创作