How to Build Pivot Tables in Salesforce (No Code, Editable)

Build a pivot table inside Salesforce where you can type in the cells and save. Step by step, with a $39M supply agreement as the example.
How to build pivot tables in Salesforce: a Valorx Wave Matrix of products by month

You can build a pivot table in Salesforce that you edit like a spreadsheet: products down the side, months across the top, a number in every cell. Type a new number, save, and the record in Salesforce changes. This guide follows the video step by step.

Jump to a chapter

What you'll build

  • A pivot table on live Salesforce records
  • Products as rows, months as columns
  • Cells you can type in and save
  • One view by month, quarter or week
  • No code, built in a wizard
  • Video length: 5 minutes

What a pivot table in Salesforce looks like

Three parts, the same as in a spreadsheet. Rows are the records. Columns are the time frame. Cells hold the number. The difference is the last part: here the cells are editable, and saving writes to Salesforce.

A pivot table inside Salesforce with products as rows, months as columns and editable cells
Rows, columns and editable cells. The highlighted cells are a first-quarter forecast typed in.

Why this is hard today: one forecast, four objects

The example is a memory supply agreement in our demo org: $39 million, eight products, eighteen months. To forecast it, a planner needs four things that live in four places.

A Salesforce supply forecast spread across account, sales agreement, products and schedules
Account, sales agreement, products, schedules. One agreement alone is 144 schedule rows.

In the video we count the screens it takes to see one forecast. It comes to seven. This is the fifth: a single product on the agreement, with totals but still no months.

Salesforce sales agreement product record, screen five of seven in the forecast walk
Screen 5 of 7. One product, one record page. Demo data.

So the planner does what most planners do. They rebuild it as a pivot in a spreadsheet. Leadership changes the number. Someone keys it back into Salesforce row by row, and by then a quantity has moved.

The forecast round trip from Salesforce to a spreadsheet to leadership and back
The round trip: stale by the time it lands, re-keyed row by row.
The usual wayWith a Wave Matrix
Seven screens to see one agreement's forecastOne view: account, agreement, products and months
Rebuild the numbers as a pivot in a spreadsheetThe pivot is already built, on the live records
Key the agreed numbers back in, one schedule row at a timeType in the cell and save
A separate sheet for the quarterly viewSwitch the same view to quarters or weeks

Build it in seven steps

You need Valorx Wave from the AppExchange and the Wave permission set. Everything below happens in the Matrix Wizard.

  1. Name the matrix. Ours is Memory Supply Forecast.
  2. Pick the rows. Choose the product schedule object, because that's where the monthly numbers live. For the row labels, pick the agreement, the product, and the account behind the agreement.
Matrix Wizard in Valorx Wave with Sales Agreement Product Schedule chosen as the row object
Step 2. The row object is Sales Agreement Product Schedule.
  1. Pick the columns. Same object. The field is the schedule's start date, and that becomes the months.
  2. Pick the data. Use existing records, then choose what goes in the cells. We chose planned quantity and planned amount.
  3. Set the timeline. Monthly, on a straight line. You can also telescope it, with months near term and quarters further out.
Timeline step of the Matrix Wizard set to monthly intervals with a historical view
Step 5. Monthly intervals, with past months shown read only.
  1. Add a filter. Let the planner pick agreements when the matrix opens. One matrix then serves every account.
  2. Save and surf. Pick an agreement and the pivot table opens: every product underneath, months across.

Now use it

Each cell is one schedule row in Salesforce. The Dynamic Measures menu switches between quantity, amount, or both, depending on what the meeting needs.

Wave Matrix showing planned amount and planned quantity by month with the Dynamic Measures menu open
Eight products by month, with planned amount and planned quantity side by side. Demo data.

Worked example from the video

The customer asks for more 512 GB cards in the first quarter. The new quantities go straight into three cells.

Jan20,000
Feb21,000
Mar22,000
Q1 total63,000

The row total and the column totals move as you type. Nothing is exported and nothing is re-keyed.

Typing a new forecast quantity into a Wave Matrix cell while the totals update
Typing February's number. The button at the top right already reads "Save 2 changes".

Click Save and a summary confirms which records were updated. These are schedule rows in Salesforce, so the agreement's own rules still apply.

Save Summary in Valorx Wave confirming three sales agreement product schedule records updated
The Save Summary: three schedule records updated.

Three more to build next

  • The forecast call. Opportunities as rows, close quarters as columns, amount and probability in the cells.
  • Product mix. Products as rows, months as columns, quantity in the cells.
  • The quarter view. The same agreement rolled up by quarter for the business review.
Wave Matrix for a forecast call with opportunities as rows and close quarters as columns
The forecast call matrix: amount and probability by quarter, with rules shading the cells. Demo data.

Questions this video answers

Can you create a pivot table in Salesforce?

Yes. Salesforce reports can group and summarize records, and a matrix report lays them out in rows and columns to read. A Wave Matrix is a pivot table on the live records where the cells are editable and save back.

What's the difference between a matrix report and a Wave Matrix?

A matrix report is for reading. A Wave Matrix shows the records themselves in the cells, so you can change a quantity and save it. More on reports: Salesforce matrix report.

Can one pivot table span several Salesforce objects?

Yes. The one in the video connects the account, the sales agreement, its products and the monthly schedule for each product.

Do I need code or an admin to build it?

No code. It's built in the Matrix Wizard by anyone with a Designer or Admin role in Wave.

Keep going

Recorded in a Salesforce demo org with demo data, restored after recording.

Want to see it on your own objects? Book a demo and we'll build the first matrix with you on the call.