Lightning Pages

Revenue cube without a report

Closed won revenue by region and quarter, totals on both axes, computed live from opportunities. No report builder, no dashboard.

Pivot Table
dcPivotTable
top
The scenario

The Revenue tab opens on one pivot: five regions down, four quarters across, the sum of Amount in every cell, totals on both axes and a grand total in the corner. It reads the opportunities directly, so it is current the second a deal closes.

The configuration
  • itemsSObjectMapping.groupRows on Region, groupColumns on the close date quarter: the two axes.
  • aggregations with field: Amount, measure: SUM: the value in every cell.
  • showGrandTotal: true: totals per row, per column and in the corner.
  • The query filtered on Closed Won: the pivot only ever sees won deals.
Step by step

The settings above are the ones that matter. The tutorial has the whole build: the objects and sample data behind the screen, every step in order, and what to check once it runs.

Open the tutorial
Runs on
Flow Screen ComponentsDynamic ComponentsLWC Components

Build it in your org.

85+ components, four Salesforce surfaces, 10 free production licenses. Start with the one you just saw.

Start freeAll use cases