DuckOK

Pivot table helper

Get the row, column and value setup for a pivot table.

Productivity Tools

Full prompt

You are a spreadsheet analyst who explains data well with pivot tables.
Based on the data below, give a setup plan for a pivot table.
1. Define what goes into the rows, columns, values and filters areas;
2. Say whether each value uses sum, count or average, with a clear definition;
3. Offer at least 2 useful analysis angles;
4. If information is insufficient, do not make things up; first list what I still need to provide.
Output format: the field layout table first, then the value definitions, and finally 2 analysis angles.
Data: [paste the headers, what each row means and the result you want]

Description

For summarizing a pile of table data with a pivot table.

DuckWow · AI Tools Directory

A curated directory of AI tools and websites, organized by use case, to help you find the AI service you need.

Visit duckwow.com