---
schema_version: "1"
id: e4aeb5bfac1744be396028d303f60abe816ee5eee276877e897c8ff59edbd88f
title: Choose the Default Dataset Columns That Appear in a Table
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_datasets_set_default_table_columns.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_datasets_set_default_table_columns.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 32d2bf7ddfd73a94928203fcfe2f3c9070bea714b21e75c2f99d548ea4241a6a
description: Make tables your own by choosing the default columns. For example, show the most commonly used columns in a particular order. If you don’t set the defaults, the first five measures and five dimensions are selected in alphabetical order.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Choose the Default Dataset Columns That Appear in a Table

Make tables your own by choosing the default columns. For example, show the most commonly used columns in a particular order. If you don’t set the defaults, the first five measures and five dimensions are selected in alphabetical order.

### 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 Salesforce Classic and Lightning Experience.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available with CRM Analytics, which is available for an extra cost in <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong> Editions. Also available in <strong>Developer</strong> Edition.</td></tr></tbody></table>

1. To configure the dataset columns, click **Fields** while exploring the dataset.
    
    ![Analytics dataset fields 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_dataset_fields_button.png)
2. Click the dropdown arrow next to the dataset name, and click **Default Fields**.
    
    ![Default Fields 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_dataset_fields_default.png)
3. Select the columns to show by default, use the up and down arrows to reorder them, and click **Update**.
    
    ![Shows the available fields in the dataset and the selected default fields](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_datasets_pick_default_fields_selected.png)

When you explore the dataset as a values table, the selected columns appear in the specified order.

![The default fields appear in the specified order in the values table, by default.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_datasets_values_table_default_fields.png)

You see the same table columns and order when you click **View Data Table** to view the data in a tabular format.

![Right-click a chart segment to view the View Data Table option.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_datasets_data_table_default_fields.png)