You can attach a permitted spreadsheet to ChatGPT and ask it to explain the field arrangement and expected results. OpenAI documents spreadsheet analysis and creating reviewable files; those capabilities do not establish that every returned summary is a native Excel PivotTable. Working with attached files
Define the denominator before choosing fields
This fictional dataset records completed checks out of assigned checks for two teams:
| Team | Completed | Assigned | Team completion rate |
|---|---|---|---|
| A | 1 | 2 | 50% |
| B | 9 | 10 | 90% |
Across both teams, 10 of 12 checks are complete: 10 ÷ 12 = 83.3%, rounded to one decimal place. Averaging the two team percentages gives 70%. That answers a different question because it gives the two-check team the same weight as the ten-check team.
The intended report is overall completion, so ask for sums of Completed and Assigned, then divide those totals. Keep the team-level rates if useful, but label the two measures clearly.
Help me design a PivotTable for this workbook.
One source row represents [DEFINE THE ROW].
Question: [WHAT THE REPORT MUST ANSWER].
Definitions and inclusion rules: [PASTE].
Before editing, propose Rows, Columns, Filters, and Values.
For every Values field, name the aggregation and its meaning.
If a rate is required, state its numerator and denominator and explain
whether to divide summed values or average per-row percentages.
Do not silently choose between those measures.
For the fictional check: A completed1/assigned2, B completed9/assigned10.
Expected totals: completed10, assigned12, overall rate83.3%.
Average team rate70% is a separate measure.
Show the expected report and Excel steps. Do not alter the source.
If creating a file, state whether it contains a native PivotTable or
only a static summary, and explain how I can verify that in Excel.
Build the source totals in Excel
Keep the source in a rectangular table with one header row. Select the data and use Insert > PivotTable, choosing a separate worksheet. Put Team in Rows and Completed and Assigned in Values. For this fixture, both Values fields should summarize by Sum. Microsoft's PivotTable instructions
The expected total row is Completed 10 and Assigned 12. Calculate the overall rate from those totals using a clearly labeled worksheet formula or an appropriate measure in your workbook. Do not assume that an Average of the source Rate column implements that calculation.
If Completed appears as Count, inspect the source values and the field's aggregation. Text in a numeric column can change Excel's default summary behavior. Correct the source representation only after checking what each value means. Values settings and source preparation
Add one row and refresh the actual report
Add fictional Team C with Completed 0 and Assigned 3. After the source includes it and the PivotTable is refreshed, the totals should become 10 and 15; overall completion is 66.7%. The unweighted average of the three team rates is 46.7%, a different measure again.
Excel tables include newly added rows as a PivotTable source when refreshed. A fixed source range may require an updated range as well as a refresh. Right-click the PivotTable and select Refresh, then inspect the totals. Source growth and refresh
These are authored arithmetic checks, not a claimed ChatGPT or Excel execution. If a delivered workbook has no PivotTable field controls when you select its summary, inspect whether it contains only a pasted table.
For formula-chain repair, ChatGPT for Excel covers a different workbook task. Keep the accepted field arrangement, refresh instructions, and rate definition beside this report so next month's reviewer knows what 66.7% measures.