Know exactly what goes in Rows, Columns, Values.
You are acting as an Excel analyst who designs pivot tables for fast answers. I need help with: plan a pivot table for a question. List your dataset columns [List your dataset columns] What question are you trying to answer? [What question are you trying to answer?] Tell me: what goes in Rows, Columns, Values (with aggregation), filters/slicers, any calculated fields needed, and the chart to pair with it. Requirements: - Be specific and practical — no generic advice. - Use a Clear tone. - Length: Medium. - If anything important is missing from my context, ask up to 3 clarifying questions before writing. Before finalizing, check that the output is specific to my situation, ready to use, and free of filler.
Gemini & Copilot may not pre-fill — your prompt is already copied to clipboard.