Business & Strategy

Pivot Table Design

Design pivot tables

The prompt

Help me design a pivot table to answer the business question I have. Recommend which fields to use for rows, columns, values, and filters. Show me how to structure it for the analysis I need and what additional views would be insightful.

How to use it

Copy the prompt, paste it into ChatGPT, Claude, Gemini or Perplexity, and replace anything in brackets with your own details. The more context you add about your situation, the better the answer.

  • excel
  • beginner
See all 300 prompts in Business & Strategy

Want prompts like these built into how your team works?

DAPT builds custom AI tools and trains your team to run them. Tell us what you're doing by hand.

Book a call