In the pack: ChatGPT, Claude & Gemini Prompts for Data Analysis, Excel & Google Sheets
Period-Over-Period Comparison Table
Prompt
Data headers and three sample rows, including the date column format: {{SHEET_STRUCTURE}}
The measure and the comparison I want (month on month, same month last year, quarter to date versus plan): {{COMPARISON_SPEC}}
How the calendar works for this business (calendar months, fiscal year start, 4-4-5 weeks): {{CALENDAR_RULES}}
App and version: {{SPREADSHEET_APP}}
Do this:
1. Define each period precisely and say how partial periods will be handled, since comparing a half-finished month to a full one misleads.
2. Give the helper columns or formulas that assign each row to a period and, if needed, a fiscal period.
3. Build the comparison table: current, prior, absolute change and percentage change, with formulas, and the rule for when the prior value is zero or blank (show "n/a", not an error or 100%).
4. Add a check that both periods contain the same number of trading days or flags when they don't.
5. Offer a chart suggestion in one sentence.
Mention one trap: percentages of small bases. State your assumptions.
Customize this prompt
Fill in the variables below to personalize this prompt:
Model Settings
Recommended Models
Temperature
Max Tokens
Additional Notes
About this prompt
“Period-Over-Period Comparison Table” is a free prompt for ChatGPT in the Business category, 181 words long, added to The Prompt Index on October 28, 2026 by The Prompt Index. Copy it with the button above, paste it into ChatGPT or any other AI chat assistant, and send it.
It has 4 placeholders to fill in first:
{{SHEET_STRUCTURE}}, {{COMPARISON_SPEC}}, {{CALENDAR_RULES}}, {{SPREADSHEET_APP}}.
Use the “Customize this prompt” fields to personalise it before you copy.
Recommended models: ChatGPT, Claude, Gemini.
0 upvotes, sent to an AI tool 0 times, viewed 9 times.
Browse all Business prompts, the AI prompt database or use the AI prompt finder to search every prompt.