---
schema_version: "1"
id: 49344c4acd52379883285b98de197d6b79840afc88a66d13cbdea7d74996f5e0
title: Navigate Compare Table Columns
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_explorer_compare_table_nav.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_explorer_compare_table_nav.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e6f3b1d41d8c93cf676a245f365563e96197cf9f3d5bddb8e403b6659906644b
description: Create columns and navigate between existing ones using clicks or keystrokes.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Navigate Compare Table Columns

Create columns and navigate between existing ones using clicks or keystrokes.

You can navigate columns in the column editor using arrow buttons or your keyboard's left and right arrow keys.

![Explorer compare table column editor with navigation arrows](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_compare_table_nav.png)

When you reach the right-most column, the right arrow button becomes an add-column button. You can click the add-column button or use your keyboard's Enter key to add a formula column.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note You can add up to 26 columns in the Compare Table.

![Explorer compare table column editor with add-column button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_compare_table_add_formula_column.png)

As you navigate through a compare table, you can freeze up to five columns while you scroll through the remaining data. From a column header’s dropdown menu, select **Freeze Columns Up to Here**.

Alternatively, go to the Layout section in the table properties panel (1). Select **Customize Frozen Columns** in the Layout section (2) and set the number of table columns to freeze (3). A dark gray line indicates the end of the freeze pane.

![Freeze columns in compare table](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_comparetable_freezepane.png)

You can also delete columns from the compare table by selecting **Delete** in the context menu of any measure or dimension.

![Explorer compare table column delete buttons](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_compare_table_column_delete.png)

Use the **Close** button to exit the column editor without applying changes to the column.

Turn on Repeat Row Values to replicate group dimension values, such as region, product, on every row. Repeat Row Values improves the readability of large datasets because you won't need to scroll back to see the first occurrence of the group value. Click the Formatting icon and expand the Layout section. Click **Repeat Row Values** to enable.

![Repeat Row Values turned on for a compare table](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_compare_table_repeat_row.png)

The table must have a minimum of three field groupings and Show Subtotal must be on.

To show or hide column totals, enable **Show Totals** then select Show or Hide Totals on the column.

![Hiding a column in a compare table.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_column_show_hide_totals.png)

## Compare Table Considerations

To avoid this issue, keep subtotals enabled for all dimensions to expand or collapse rows. If it’s necessary to turn off subtotals, avoid collapsing the first dimension.