# Pivot or group an Enquiries report by Stage or Revenue Stage

> In SkedX CRM, open the Leads report and choose Pivot (or Grouped). Click + Add row field, type “stage” and pick Stage or Revenue Stage; pick a column field such as Status. Stage is where each enquiry stands on its stage line — its own stage when it is on the line, else where its status points, else the first stage — the same answer as the Enquiries list and the record’s stage line. The profile chip above the report decides whose stages are read; All profiles reads Enquiries’ stages. Revenue Stage is the stage of the enquiry’s latest deal still on the board, else that deal’s status; enquiries with no deal show as (empty). Stage is offered only where your company uses stages. Both can also filter the report and be a column in the table and the export (the export writes each stage’s key).

Product: SkedX CRM · Topic: Analytics · Draft — steps not yet re-verified in the live product · Updated 2026-11-17

Count your enquiries by the stage they stand on — or by their deal’s stage — in the Leads report.

## Step 1: Open the Leads report in Pivot

Open the Leads report and click **Pivot**. Where your company has profiles, pick the profile chip above the report first — its stages are the ones read.
Open it directly: https://crm.skode.ai/reports/leads

## Step 2: Add Stage as a row

Click **+ Add row field**, type **stage** and pick **Stage** — or **Revenue Stage** for the deal’s stage.

## Step 3: Read the counts

Pick a column field such as **Status**. Each row is a stage, in the stages’ own names, with its count under each status.

## Common questions

### I don’t see Stage.

Stage is offered where your company uses stages — two or more on the stage line. An admin sets them in the profile’s Edit layout.

### Stage or Revenue Stage — which do I want?

Stage is where the enquiry itself stands on its stage line. Revenue Stage is the stage of its latest deal. An enquiry with no deal has no Revenue Stage.

### Why does a profile show different stages?

A profile can have its own stages. The profile chip above the report decides whose are read; All profiles reads Enquiries’ stages.

### Does it match the Enquiries list?

Yes. Stage uses the same rule as the list and the record’s stage line, so the counts agree with what each enquiry shows.

### How do I see the people behind a number?

Double-click the number: its rows open as a new sheet. A bold row that adds up the rows under it, like a campaign’s own row, opens all of its rows.

### How do I open a person from the pivot?

Double-click their name in the row labels. One person opens their enquiry; several people with that name open a sheet of them.

### The pivot shows only first names.

Pick Full Name as the row field. It is offered for every company; a company that uses Full Name no longer sees First Name and Last Name.

Videos and screenshots © 2026 SkedX, with sample data only. Share and link to them freely; copying the SkedX product or its design is not allowed. Terms: https://skode.ai/terms/

## Related guides
- Group a list by stage, status, owner or any field: https://skode.ai/help/crm/profiles/group-a-list-by-stage-status-owner-or-any-field/
- Share stages between profiles, or give one profile its own: https://skode.ai/help/crm/profiles/share-stages-between-profiles-or-give-one-its-own/
- Share a pinned report on Analytics with your team: https://skode.ai/help/crm/analytics/share-a-pinned-report-on-analytics/

Source: https://skode.ai/help/crm/analytics/pivot-or-group-an-enquiries-report-by-stage/