← Back to all Walkthroughs 🔍 Illustrative Example

Turning a Raw Orders Export Into an Actual Pivot Table

Imagine a small e-commerce owner staring at a raw orders export, needing to see monthly revenue by product category but unsure where to even start with a pivot table.

This is a generated example showing what the prompt produces — not a real client's project or a testimonial.

The Prompt (filled in)

I have a spreadsheet with these columns: Order ID, Date, Customer Name, Product Category, Quantity, Unit Price, Total, Region. Tell me exactly which fields to put in Rows, Columns, Values, and Filters to build a pivot table that shows monthly revenue by product category.

Based on the real prompt "Pivot Table Setup Planner" from the Productivity category.

Example Output

Rows: Product Category
Columns: Date, grouped by Month (right-click any date in the pivot table and choose "Group" → "Months" — don't create a separate month column first, the grouping tool handles it)
Values: Sum of Total
Filters: Region (optional — add this if you ever want to isolate one region without rebuilding the table)

This gives you a grid with product categories down the side and months across the top, each cell showing that category's revenue for that month — ready to spot trends or seasonality at a glance.

💡 Why This Works

Listing every actual column header, not just describing the data vaguely, is what let the AI give an exact field-by-field pivot table setup instead of generic pivot table theory you'd still have to translate yourself.

One of 8 free example walkthroughs

See exactly what our prompts produce before you copy one — no email needed, ever, for this section.

See More Walkthroughs →