
Sometimes visualizing data in a chart isn't enough for all analyses. To review, interact with, and export the data that makes up your charts in Amplitude Analytics, use the **breakdown table**, which appears below your chart.

Some charts—including Data Tables, Personas, Pathfinder, Pathfinder Users, Compass, and Experiment Results—don't have a breakdown table.

## Sort your table's fields

The columns, or fields, in your breakdown table depend on multiple factors, such as:

- The type of chart you use for analysis.
- The type and number of events.
- The type of measurement.
- Whether you use segment or group-by properties.

Some columns in your breakdown table are **fixed**. A fixed column appears at the far left, highlighted in blue, and Amplitude adds or appends it depending on your analysis. For example, adding an additional event, segment, or segment group-by creates a new fixed column, but adding an additional group-by to an event only appends the event's group-by fixed column. Resize a fixed column by dragging the divider between the columns to the right or the left.

Click a column name in your breakdown table to sort the column in descending or ascending order.

{% callout type="note" %}
Amplitude sorts fixed column values as strings.
{% /callout %}

## Change the summary column

Some charts, such as Segmentation and User Sessions charts, include a **summary column**. Modify the summary column by choosing a **row aggregate** in the dropdown menu. Select from average, median, change (first row minus last row values), or sum (available only for event totals, properties, and formulas).

## Set the number of series to display

Each breakdown table interacts with your charts, and vice versa. A change to the breakdown table, such as clicking the checkbox by a row name, modifies the chart by removing the unclicked series. Clicking checkboxes near the far-left field name selects or unselects all rows, and modifies the chart by adding or removing all data.

{% callout type="note" %}
Regardless of what you select or unselect in the breakdown table, the exported .CSV includes **all** rows and values.
{% /callout %}

## Modify the table breakdown

Select the specific number of series or rows you want to display in your breakdown table. Click the _Breakdown by:_ dropdown to choose a default or enter a numerical value between 1-30. As long as it's saved, the _Breakdown by:_ selection persists through sorting and refreshing, and applies to any dashboards that include your chart. When Amplitude receives new data, the top values or events update automatically.

To turn off a _Breakdown by:_ selection, ensure only the values and events you want to keep maintain a checkmark. Your Breakdown table then notes that only a specific number are selected. Turn it back on by clicking the _Reset to top..._ hyperlink.

## Export to .CSV

Click to export your breakdown table as a .CSV file. There are [.CSV download limits](/docs/data/csv-import-export) that depend on the type of chart and group-by in use.

## Search for values

Use the search bar to search for any values in your breakdown table. Searches start automatically once you enter a value, and update when you modify or remove the value. A search result doesn't impact the chart or the data you can export.
