# Using tables as visuals Use a table visual to see a customized table view of your data. To create a table visual, choose at least one field of any data type. You can add as many columns as you need, up to 200. You can also add calculated columns. Table visuals don't display a legend. You can hide or display the title on a table. You can also hide or display totals, and choose to show totals at the top or the bottom of the table. For more information, see [Analytics formatting per type in Quick](analytics-format-options.md). **To create a table visual** 1. Open Amazon Quick and choose **Analyses** on the navigation pane at left. 1. Choose one of the following: + To create a new analysis, choose **New analysis** at upper right. For more information, see [Starting an analysis in Quick Sight](creating-an-analysis.md). + To use an existing analysis, choose the analysis that you want to edit. 1. Choose **Insert** from the file menu and then **Add Visual**. 1. At lower left, choose the table icon from **Visual types**. 1. On the **Fields** list pane, choose the fields that you want to use. If you want to add a calculated field, choose **Insert** on the file menu and then **Add Calculated Field**. To create a nonaggregated view of the data, add fields only to the **Value** field well. Doing this shows data without any aggregations. To create an aggregated view of the data, choose the fields that you want to aggregate by, and then add them to the **Group by** field well. **To show or hide columns on a table** 1. On your visual, choose the field that you want to hide, then choose **Hide column**. 1. To display hidden columns, choose any column, then choose **Show all hidden columns**. **To transpose columns to rows and rows to columns** + Choose the transpose icon ( ![\[alt text not found\]](http://docs.aws.amazon.com/quick/latest/userguide/images/transpose-icon.png)) near the top right of the visual. It has two arrows at a 90 degree angle. **To vertically align columns** 1. On your visual, choose the **Format visual** icon ( ![\[alt text not found\]](http://docs.aws.amazon.com/quick/latest/userguide/images/format-visual-icon.png)) near the top right of the visual. 1. In the **Properties** pane, choose **Table options**, and choose your table's vertical alignment. **To wrap the text for headers** 1. On your visual, choose the **Format visual** icon ( ![\[alt text not found\]](http://docs.aws.amazon.com/quick/latest/userguide/images/format-visual-icon.png)) near the top right of the visual. 1. In the **Properties** pane, choose **Table options**, and select **Wrap header text**. **To rearrange columns in a table chart** 1. Open the analysis with the visual that you want to sort. Visuals pane will be open by default. 1. Do one of the following: + Drag and drop one or more fields in **Field wells** to rearrange their order. + Select a field directly in the table and choose the left or right arrow on **Move column**. # Using field styling You can render URLs in a table as links by using the **Field styling** pane of the format visual menu. You can add up to 500 rows of links for each page in a table. Only https and mailto hyperlinks are supported. **To add links to your tables** 1. From the Quick homepage, choose **Analyses**, and then choose the analysis that you want to customize. 1. Choose the table that you want to change. 1. On the menu at the upper right of the table, choose **Format visual**. 1. For **Format visual**, choose **Field styling**. 1. On the **Field styling** pane, choose the field that you want to style from the menu. 1. In the **Url options** section of the **Field styling** menu, choose **Make URLs hyperlinks**. After you add links to your table, you can choose where you want the links to open when they're selected in the **Open in** section of the **Field style** pane. You can choose to have links open in a new tab, a new window, or in the same tab. You can also choose how you want to style the link in the **Style as** section of **Field style** pane. Your links can appear as hyperlinks, icons, or plain text, or you can set a custom link. To adjust the font size of a link icon or URL, change the **Font size** in the **Cells** section of the **Table options** pane of the **Format visual** menu. You can set any URLs in your table that point to images to render in the table as images. Doing this can be useful when you want to include an image of a product as a part of a table. **To show URLs as images** 1. From the Quick home page, choose **Analyses**, and then choose the analysis that you want to customize. 1. Choose the table that you want to change. 1. On the menu at the upper-right of the table, choose **Format visual**. 1. In the **Format visual** menu, choose **Field styling**. 1. In the **Field styling** pane, choose the field that you want to style from the menu. 1. In the **Url options** section of the **Field styling** menu, choose **Show URLs as images**. After rendering images in a table, you can choose how to size the images in the **Image sizing** section of the **Field style** pane. You can fit images to their cell's height or width, or you can choose not to scale the image. Images fit to a cell's height by default. # Freeze columns to table visuals Freeze columns You can freeze columns to your table visuals to lock specific columns in place on screen. This allows essential information to remian visible while readers scroll across the table. You can freeze columns one at a time, or you can freeze groups of columns in one action. All pinned columns are fixed to the far left side of the table and stay visible on screen at all times. This allows Quick readers to have a constant reference point for key data or information as they interact with other parts of the table. **To freeze columns to a table** 1. On the table that you want to freeze a column to, choose the column that you want to pin. 1. Choose one of the following options. + To freeze a single column, choose **Freeze column**. + To freeze all columns up to the column that you choose, choose **Freeze up to this column**. If your table has multiple pinned columns, you can reorder the columns in the order that you want. To adjust the order of the pinned columns on a table, choose the header of the column that you want to move, and then choose **Move** in the direction that you want. **To unfreeze columns from a table** 1. On the table that you want to change, choose the pinned column that you wnat to unpin. 1. Choose one of the following options. + To unfreeze a single column, choose **Unfreeze column**. + To unfreeze all frozen columns, choose **Unfreeze all columns**. # Custom total values Quick authors can define the total and subtotal aggregations for their table or pivot table visuals from the field wells. For tables,the custom total menu is only available if totals are toggled on for the visual. **To change the aggregation of a total or subtotal** 1. Navigate to the analysis that you want to change, and choose the table or pivot table visual whose total you want to define. 1. Choose the field that you want to change from the field wells. 1. Choose **Total**, and then choose the aggregation that you want. The following options are available. + **Default** – The total calculation uses the same aggregation as the metric field. + **Sum** – Calculates the sum of the data in the visual. + **Average** – Calculates the average of the data in the visual. + **Min** – Calculates the minimum value of the data in the visual. + **Max** – Calculates the maximum value of the data in the visual. + **None (HIDE)** – Totals are not calculated. When you choose this option, the total and subtotal cells in the visual are left blank. If the outer dimension is sorted with the metric field that calculates the total or subtotal, the dimension is sorted alphabetically. When you change the value from **None (HIDE)** to another value, the outer dimension is sorted by the subtotals that are calculated with the specified aggregation type. The following limitations apply to custom totals. + Conditional formatting is not supported for custom totals. + Total aggregations aren't supported for string columns. Total aggregations include **Min**, **Max**, **Sum**, and **Average**. + Date columns are incompatible with **Average** and **Sum** total aggregation functions. # Sorting tables In Amazon Quick, you can sort values in a table by fields in the columns headers of the table or with the **Sort visual** tool. You can sort up to 10 columns in a single table. Quick can also use an off-visual sort You can sort columns in an **Ascending** or a **Descending** order. The following image shows the **Sort visual** icon and pop over. ![\[The Sort visual icon and the Sort visual pop over that it opens.\]](http://docs.aws.amazon.com/quick/latest/userguide/images/table-sort-icon.png) ## Single column sort options Quick Authors can access single column sort options from the field wells, the column headers, or from the **Sort visual** menu. Use the procedure below to use set up a single column sort on a table in Quick. 1. Open the [Quick console](https://quicksight.aws.amazon.com/). 1. Open the analysis that you want to work in and navigate to the table that you want to sort. 1. Choose the header of the column that you want to sort. 1. For **Sort by**, choose the arrow icon, and then choose the field that you want to sort by. You can also set up a single column sort in the **Sort visual** menu. To access the sort visual menu, choose the **Sort visual** icon in the on-visual menu. In the **Sort visual** menu, choose the field that you want to sort by, and then choose if you want the sort in an ascending or descending order. By default, new sorts are sorted in an ascending order. When you are finished, choose **APPLY**. Tables that use single column sorting are sorted one column at a time. When a user chooses a new column to sort by, the previous sort order is overridden. To make changes to a single column sort, open the **Sort visual** menu annd use the dropdown menus to choose a new field or sort order. When you are finished with your changes, choose **APPLY**. To reset a table to its original state, open the **Sort visual** menu and choose **RESET**. ## Multi column sort options Quick authors can access multi column sort options from the **Sort visual** menu. Use the procedure below to set up a multi column sort for a table. 1. Open the [Quick console](https://quicksight.aws.amazon.com/). 1. Open the analysis that you want to work in and navigate to the table that you want to sort. 1. Choose the **Sort visual** icon to open the **Sort visual** menu. 1. Alternatively, choose a header that you want to sort. 1. For **Sort by**, choose the arrow icon, and then choose **Multiple fields**. 1. In the **Sort visual** menu that opens, choose a field from the **Sort by** dropdown, and then choose whether you want the field sorted in an ascending or descending order. 1. To add another sort, choose **ADD SORT**, and repeat the workflow from Step 4. You can add up to 10 sorts to each table. 1. When you are finished, choose **APPLY**. Columns are sorted in the order that they are added to the **Sort visual** menu. To change the order that columns are sorted by, open the **Sort visual** menu and use the **Sort by** dropdowns to reorder the sorts. When you are finished, choose **APPLY** to apply the new sort order to the table. To reset a table to its original state, open the **Sort visual** menu and choose **RESET**. ## Off visual sort options Quick authors can configure an off-visual sort to sort the values in a table by a field and aggregation that is a part of the dataset that the table uses but not in one of the table's field wells. One off-field sort can be configured to a single table at a time. Use the procedure below to configure an off-visual sort. **To add an off-visual sort to a table** 1. Open the [Quick console](https://quicksight.aws.amazon.com/). 1. Open the analysis that you want to work in and navigate to the table that you want to sort. 1. Choose the header of any column in the table. 1. For **Sort by**, choose the arrow icon, and then choose **Off-visual field**. 1. In the **Off-visual field** pane that appears, open the **Sort by** dropdown menu and choose the field that you want to sort. 1. For **Aggregation** open the dropdown menu and choose the aggregation that you want to use. 1. For **Sort order**, choose if you want the sort to be in an ascending or descending order. 1. When you are finished, choose **Apply**. After a off-visual sort is applied to a table, the sort is shown in the **Sort visual** menu. The sort order of a table that contains an off-visual sort depends on the sort configuration of the table when the off-visual sort is added. If an off-visual sort is added to a table that already has a single or multi column sort configured, the off-visual sort overrides all other sorts. If the off-visual sort is applied before single or multi column sorts, you can add and reorder more sorts to the table.