# Features of Tables

In this chapter you find the documentation of the table view, which is generally used throughout the Open Systems Pharmacology Suite.

## Overview‌

In PK-Sim® and MoBi®, tables are often used for input and output, for instance in parameter lists, history, and the chart editor. The tables have several useful features whose availability in some cases depends on the context.

In this section we describe the most important features on the example of the table **Physiology > Organ composition** in the tab **Anatomy & Physiology** of an individual in PK-Sim®.

![Organ Table](https://2377851789-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LNl6UIiFP7k0sNQthlR%2F-LQ_9glLDwP6K9IEV9eY%2F-LOWPyzUNAkJHJvcKOGl%2FTable_Original.png?generation=1541443091749601\&alt=media)

Before we describe the features in more detail in the following subsections, we give a brief overview of the most used concepts and actions:

* Column width - you can change the width of a column by dragging the separator line between two column headers ![Image](https://2377851789-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LNl6UIiFP7k0sNQthlR%2F-LOWPv3bS-p6gLjXajFs%2F-LOWPyznHWk9piJHktC1%2FColumnWidth.png?generation=1539232758546648\&alt=media).
* Column order - you can change the order of columns by dragging a column header to another location in the Column Header Row.
* Sorting - you can sort the rows by the content of a column by just clicking on the column header. The sorting column is marked by a triangle on the right of its header.
* Filtering - you can filter the rows by a certain value of a column by hovering with the mouse over the right hand side of the column header and clicking on the filter symbol , which then appears.
* Grouping - you can group the rows by dragging a column header to the grouping panel and vice versa.

Right-click on a column header to get a **context menu** with more features. In the following, we simply use **Context Menu** to denote the context menu of a column header.

The screenshot below shows a table

* grouped by the Organs/Compartment column,
* sorted by the Organ/Segment column,
* filtered by Name = 'Fraction vascular',
* and the name column moved left to the value column.

![Organ Table With Changes Applied](https://2377851789-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LNl6UIiFP7k0sNQthlR%2F-LQ_9glLDwP6K9IEV9eY%2F-LOWPyzZkgCU7ifCFexy%2FTable_OrganizedWithDescription.png?generation=1541443096152379\&alt=media)

## Sorting‌

* To sort the rows of a table ascendingly by a column, click the column header.
* Click on the column header again to toggle the sort order between ascending and descending row values.
* Select **Clear Sorting** from **Context Menu** to undo the sorting.
* To sort by multiple columns, you need to press the shift key when clicking on the column headers for sorting. The ordering within a multiple column sort depends on the sequence with which the columns have been selected for sorting. To alter this sequence you deselect a column by **Clear Sorting** from **Context Menu** and then re-select it.

## Grouping‌

* To group the rows of a table by a column, drag the column header from the **Column Header Row** to the **Grouping Panel**, if visible, or select **Group by this column** from its **Context Menu**.
* To show the **Grouping Panel**, select **Show Group By Box** from **Context Menu**.
* You can group by several columns hierarchically. In order to do so drag a column header to the left or to the right of another column header in the **Grouping Panel**.
* To ungroup the rows, drag the corresponding column header from the **Grouping Panel** back into the **Column Header Row** or select **Ungroup** from the **Context Menu** in the **Grouping Panel**.

{% hint style="info" %}
Note that the grouping feature is not available for all tables.
{% endhint %}

## Filtering‌

To filter the rows of a table do one of the following:

* Hover with the mouse over the right hand side of the column header and click the appearing filter symbol ![Image](https://2377851789-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LNl6UIiFP7k0sNQthlR%2F-LNl8OtfcMDLiBgLFLYU%2F-LNl8QxsgRYl9udHfFX8%2FFilterSymbol-Icon.png?generation=1538422851061653\&alt=media). Then select one or more values in the values list. The filter condition is displayed at the bottom of the table, where you can delete or edit it.
* Select **Show Auto Filter Row** from **Context Menu**. An auto filter row appears as first row in the table. There you can enter values; use \* as wildcard.
* Select **Filter Editor** from **Context Menu**. An filter editor dialog appears, where you can combine conditions for different columns.
* Select **Show Find Panel** from **Context Menu**. The find panel with a single search field appears above the **Grouping Panel**. Here you can enter some text and all rows of which any field contains that text are displayed.

You can easily combine different filter features, as exemplary shown in below.

![Organ Table With All Features Applied](https://2377851789-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LNl6UIiFP7k0sNQthlR%2F-LQ_9glLDwP6K9IEV9eY%2F-LOWPyzljepwWg1uq52O%2FTable_AllFilterFeatures.png?generation=1541443092916554\&alt=media)

## Select columns‌

* Select **Column Chooser** from **Context Menu**.
* Drag a column header from **Column Chooser** to **Column Header Row** to show the column.
* Drag a column header from **Column Header Row** to **Column Chooser** or outside the table to hide the column.

{% hint style="info" %}
The column chooser is not available for organ composition table.
{% endhint %}

## Arrange columns‌

* You can change the order of columns by dragging a column header to another location in the **Column Header Row**.
* You can change the width of a column by dragging the separator line between two column headers ![Image](https://2377851789-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LNl6UIiFP7k0sNQthlR%2F-LOWPv3bS-p6gLjXajFs%2F-LOWPyznHWk9piJHktC1%2FColumnWidth.png?generation=1539232758546648\&alt=media).
* You can adjust the width of a single column to fit its contents by double clicking its column header.
* To automatically set an appropriate column width for all columns, select **Best Fit (all columns)** from **Context Menu**.