---
schema_version: "1"
id: 1fd322af647df73791138ed6ac5e8e9dff47524a431f30cd37cbc0d9fa98d75a
title: Columns and Filters Options for Table Reports in Salesforce Spiff
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_report_options.md
canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_report_options.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 0e0a34de1cfabf7864fc118a7ca770d3af2dfbf6950b2fb1a8f2cd00eab3c878
description: After you create a custom table report, use the Columns and Filters ribbon for additional options. Group records by a selected column, and aggregate numerical column data with pivots.
products:
  - Sales Cloud
  - Sales Enablement
release: "264"
---
# Columns and Filters Options for Table Reports in Salesforce Spiff

After you create a custom table report, use the Columns and Filters ribbon for additional options. Group records by a selected column, and aggregate numerical column data with pivots.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Enterprise</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available for an additional cost in: <strong>Professional</strong> Edition with Web Services API Enabled</td></tr></tbody></table>

## Columns

To reorder columns in the table report, click the **Columns** button in the Columns and Filters ribbon. To add or remove a column from the report, select or deselect the column.

## Row Grouping

Group records by any column with Row Groups. The order in which you add columns to the group is the order in which the report groups records. For example, drag Payout Rule and Rep columns from the list in the right panel into the Row Groups section. The report groups records first by Payout Rule, then by Rep.

After you group records, you can use the arrows next to each group to explore each group and view the corresponding records.

The report aggregates numerical data for each grouping.

## Pivot Mode

To aggregate numerical column data, turn on **Pivot Mode**. When this option is turned on, all columns that don’t contain numerical data are removed. Pivot mode maintains existing groupings in the report.