Workflow · Clean · Opening soon
Pivot table from raw data
Turn this raw sales export into a pivot table of revenue by region and month. Use the grouped result to review revenue by region and month.
Someone typed
“turn this raw sales export into a pivot table of revenue by region and month”
The agent read it as
Turn this Raw sales export into a pivot table of revenue by region and month.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
Raw sales export
CSV export · 24 rows
Step
Total revenue by region and month
Step 1
Result
Regional Monthly Revenue
17 rows
Schedule
Runs when you say
Proposed
- FileRaw sales exportCSV export · 24 rows
- StepTotal revenue by region and monthStep 1
- ResultRegional Monthly Revenue17 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 17 rows came out.
- Download Raw sales export sample (24 rows)Google Sheets: open the sales sheet and use File > Download > Comma-separated values (.csv)
What you get back
The result of that run, the rows to look at first.
Regional Monthly RevenueSample data17 rows
| Region | Month | Revenue |
|---|---|---|
| Central | 2026-09-01 | 640 |
| Central | 2026-10-01 | 1,910 |
| Central | 2026-11-01 | 705 |
| East | 2026-09-01 | 760 |
| East | 2026-10-01 | 2,700 |
| East | 2026-11-01 | 940 |
| International | 2026-10-01 | 1,450 |
| International | 2026-11-01 | 1,710 |
| North | 2026-09-01 | 1,010 |
| North | 2026-10-01 | 995 |
| North | 2026-11-01 | 1,795 |
| South | 2026-09-01 | 1,250 |
How do you turn this raw sales export into a pivot table of revenue by region and month?
Upload the Google Sheets export of your raw sales data. Mammoth groups the rows and totals revenue by region and month, then returns a pivot table you can review and export.
How it works
How to use the Regional Monthly Revenue workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Regional Monthly Revenue: questions
What export should you use?
Use a file exported from Google Sheets that has the raw sales rows you want to summarise. The file should include the columns needed for region, month, and revenue.
What happens to rows that do not match the rules?
Rows that do not fit the grouping rules are left out of the pivot result or stay unchanged, depending on the workflow step. You can review those rows separately and adjust the rules if needed.
How do you change the rules?
Edit the step in plain words, for example, change the grouping fields or the measure you want to total. Then run the workflow again on the same exported file.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Remove duplicate rows, catch invoices paid twice, match messy names to a master list, standardise spellings and turn wide tables long.
- Remove duplicatesOne row of each, with a Copies column saying how many there wereSee the workflow Template
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.See the workflow Built by the agent
- Duplicate invoice checkPairs of bills that look paid twice: same supplier, same amount, close dates or the same numberSee the workflow Template
- Standardise namesA Standard name for every row, so spellings of the same name group togetherSee the workflow Template
- Combine first and last nameCombine first and last name columns into one full name column, trim extra spaces, and keep department in the same row.See the workflow Built by the agent