---
schema_version: "1"
id: 22374350577253a0609784e91cdcf91156788cbe8d9cd8f2f2d19c5b10e2dc66
title: Manage the View of Data in a Values Table
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_explorer_values_table.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_explorer_values_table.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: e5a2c29ce63e12bc529bb398c59ee79c0ef2cd38abb4fcb0967b268cf42919b2
description: The values table displays all the columns in your dataset. You can customize the view of columns in a values table, and you can sort the row values using any column except for the index column.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Manage the View of Data in a Values Table

The values table displays all the columns in your dataset. You can customize the view of columns in a values table, and you can sort the row values using any column except for the index column.

On the left-hand side of the values table are measure and dimension (grouping) tiles representing all the visible columns in your dataset. To move a measure or grouping, click and hold its tile, then drag the tile to a new position. Release the tile when the position indicator is in the correct position (1).

![CRM Analytics values table showing drag-and-drop operation](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_table_values_drag_drop.png)

To remove a measure or grouping from the table, click the x button in its tile (1). To access the Edit Columns dialog, where you can hide or show any column, click the pencil button (2). You can also add, edit, or remove filters (3). To sort the rows by a column, click its heading cell until an arrow appears in the direction you want to sort (4).

![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 When sorting a values table by a column, that column’s null records are excluded from the table. To prevent the exclusion of null records, assign a default value to those records.