# Table toolbar

The table ribbon is divided into 8 sections based on the functionality provided. Let’s explore each of them.

## 1. Style

* You can customize the look and feel of the report with the options in this section. Set the font style, size, color, and background fill. Select a row, column, or cell to enable the bold, italicize, underline, background, and font color options. [Learn more about styling and formatting tables.](/analytics+/working-with-analytics+/5.-tables/5.5.-formatting-data.md)

<figure><img src="/files/q8kyQeQ4Q7kwbwzo1B5l" alt=""><figcaption><p>Applying font styles</p></figcaption></figure>

* You can hide columns by selecting them and clicking on the hide icon. Enable columns from the series window.&#x20;

<figure><img src="/files/yQ0kb9OoLYItsqavwxJe" alt=""><figcaption><p>Hiding columns</p></figcaption></figure>

## 2. Alignment

This section provides options to:

* Arrange your data according to the content, based on the canvas, or fit the maximum possible data in the available space.
* Increase or decrease the padding between rows.
* Change the horizontal and vertical alignment of the content within a cell.

[Learn more about styling and formatting tables.](/analytics+/working-with-analytics+/5.-tables/5.5.-formatting-data.md)

<figure><img src="/files/THYOTBENwdikJ3iFTERn" alt=""><figcaption><p>Alignment options</p></figcaption></figure>

## 3. Number

The number formatting section provides options to:

* Set the scaling factor (thousands, millions, billions, etc) at report level or measure/cell level for data with mixed granularities i.e. some of the data may have values in thousands and some values may be in millions.&#x20;
* Express data such as rates as a percentage.
* Add a prefix/suffix.
* Specify the decimal precision.

In the example below, we have used the number formatting options to apply a scaling factor of millions, added a $ prefix, and increased the decimal precision of the relative variance. [Learn more about number formatting.](/analytics+/working-with-analytics+/5.-tables/5.6.-number-formatting.md)

<figure><img src="/files/E6YnmzCZ94kRRcKk6ZoR" alt=""><figcaption><p>Number formatting</p></figcaption></figure>

## 4. Charts

With Analytics+, you can insert a row-level chart in a single click. All you need to do is, select the measure and choose the type of chart required for your data. [Learn more about inline charts.](/analytics+/working-with-analytics+/5.-tables/5.7.-inline-charts.md)

<figure><img src="/files/9duo8z6IofZaPEVlxGS6" alt=""><figcaption><p>Inline charts</p></figcaption></figure>

## 5. Category

* **Trellis**

In small multiples mode, you can customize the trellis layout. Click on the dropdown icon to apply a layout. You can add additional customizations by clicking **Customize grid**. [Learn more about trellis customizations.](/analytics+/working-with-analytics+/6.-trellis-customizations.md)

<figure><img src="/files/wjNBMW4QKokZr4kqRYvc" alt=""><figcaption><p>Trellis layouts</p></figcaption></figure>

* **Series**

Open the series configuration window to:

-> Set a custom width for your measures

-> Hide or display measures

-> Re-order measures

[Learn more about customizing measures.](/analytics+/working-with-analytics+/7.-customize-measures/tables-measure-series.md)

<figure><img src="/files/SBgzxpTIVToWgIp9iYbk" alt=""><figcaption><p>Customizing measures</p></figcaption></figure>

* **Split**

When you have multiple measures in your report, you can display them in different tables with the split option. [Learn more about splitting and grouping measures.](/analytics+/working-with-analytics+/8.-splitting-and-grouping-measures.md)

<figure><img src="/files/yQpOoMPtQDU8oL6FlWT1" alt=""><figcaption><p>Splitting measures</p></figcaption></figure>

## 6. Data

* **Conditional formatting:** Highlight your data instantly using Inforiver's built-in conditional formatting options. You can also specify custom conditional formatting rules. [Learn more about conditional formatting](/analytics+/working-with-analytics+/9.-conditional-formatting.md).

<figure><img src="/files/ptB4AATvckZy8hpq3H1d" alt=""><figcaption><p>Conditional formatting</p></figcaption></figure>

* **Sorting**: Sort your data based on measures or variances with options like ascending, descending, or Power BI native sort. Apply nested sorting or custom Excel-like sorting. [Learn more about sorting options.](/analytics+/working-with-analytics+/10.-sort-and-reorder-data.md)

<figure><img src="/files/B9h4ZjnihpvBAtqeLKhO" alt=""><figcaption><p>Sorting</p></figcaption></figure>

* **Ranking**: Rank your data by applying TopN rules. When hierarchical datasets are involved, you can apply nested ranking. [Learn more about ranking](/analytics+/working-with-analytics+/11.-ranking-data-topn.md).

<figure><img src="/files/HkYPEglleugrKyoud7b7" alt=""><figcaption><p>TopN</p></figcaption></figure>

* **Filter:** After assigning visual measures and dimensions, instead of using Power BI filters, you can apply filters on your data from within the Analytics+ visual. Click the filter icon at the top-right corner to view applied filters.

<figure><img src="/files/vKz4bgD0V24Sd4MC6DM2" alt=""><figcaption><p>Filter</p></figcaption></figure>

* **Blend**: Analytics+ enables you to combine related measures into a single column using the blend option. [Learn more about blending measures](/analytics+/working-with-analytics+/5.-tables/5.8.-blend-measures.md).

  <figure><img src="/files/SkNnqwhGBqOXEbeL0zVl" alt=""><figcaption><p>Blend measures</p></figcaption></figure>

  * **Formula:** You can create visual-level measures within the Analytics+ visual, without having to modify your data source. Click on the formula button to open the **Calculated Measure** side pane.

  <div data-gb-custom-block data-tag="hint" data-style="info" class="hint hint-info"><ul><li>Type the '#' key to open the suggestions window and select measures.</li><li>Click the <img src="/files/LPRy29AptM0haA3DDulm" alt="" data-size="line">icon to maximize the formula editor. The maximized view is useful for entering large, complex formulae.</li><li>Calculated measures can also be created from the <a href="/pages/ZIF1BNcsAasF38yJ5Run">Pivot data</a> window.</li></ul></div>

<figure><img src="/files/JB2vrAZd3rXQrIPUzxqr" alt=""><figcaption><p>Creating a calculated measure</p></figcaption></figure>

The new measure can then be assigned to the Actual or Comparison buckets and plotted like measures from the data source. Click on the<img src="/files/w2FovyuaHmdsqMIJYoPy" alt="" data-size="line">icon from the pivot data window to modify the formula.

<figure><img src="/files/eHmSaJJly5WoHnwL66UK" alt=""><figcaption><p>Created and plotted a formula measure</p></figcaption></figure>

## 7. Story

* **Annotations**

With its annotation feature, Inforiver Analytics+ helps you capture perspectives, descriptive stories, and priorities in your reports. [Learn more about annotations.](/analytics+/working-with-analytics+/12.-adding-notes.md)

<figure><img src="/files/BboKzkbWVGxppkVP1F5x" alt=""><figcaption><p>Annotations in Analytics+</p></figcaption></figure>

* **Templates**

The Analytics+ visual is IBCS compliant, adhering to standardized IBCS design principles.  The visual ships with integrated IBCS templates, you can instantly create an [IBCS report](https://inforiver.com/ibcs-reports-powerbi/) with in-built variance calculations in a single click. Regular rid templates are also provided.

<figure><img src="/files/spus9Qe4C3v9br3rAlKp" alt=""><figcaption><p>Templates</p></figcaption></figure>

## 8. Actions

The actions section provides single-click options like &#x20;

* Enable synchronized scrolling
* View shortcut keys and search for features&#x20;
* Apply themes
* Enable or disable KPI
* Reset all configurations to default settings&#x20;
* Open display settings.

<figure><img src="/files/lIPheTdStBDDsERWA6Sq" alt=""><figcaption><p>Actions</p></figcaption></figure>

**Synchronized scrolling**

Analytics+ facilitates comparative analysis with **synchronized horizontal & vertical scrolling.** When you scroll through one trellis panel, the other panels scroll automatically.

<figure><img src="/files/qNPnxenHivFaBRiqZgXI" alt=""><figcaption><p>Synchronized scrolling</p></figcaption></figure>

## 9. Exporting reports

Analytics+ has been designed to generate fully formatted, high-resolution PDF extracts.&#x20;

<figure><img src="/files/o0spXs6v4D0BYkH94G4Y" alt=""><figcaption><p>PDF export option</p></figcaption></figure>

{% hint style="info" %}
The PDF export option is enabled in the service only. Exports are not supported on the desktop.
{% endhint %}

<figure><img src="/files/32r8c7Wh8eXRVvoCI0qB" alt=""><figcaption><p>PDF export</p></figcaption></figure>

## 10. Backup and restore

Analytics+ supports extensive customizations for every element. It also allows you to take a backup of the visual configuration and apply the same config to other visuals. You can import/export the visual configuration as a JSON file. The JSON file can be saved to your local system and shared with other users as well. [Learn more about backup and restore.](/analytics+/working-with-analytics+/16.-backup-and-restore.md)

You can copy the JSON config to the clipboard or export it as a file.

<figure><img src="/files/bq0n9Azpddxqo8zXUZwi" alt=""><figcaption><p>Backup and restore</p></figcaption></figure>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.inforiver.com/analytics+/working-with-analytics+/1.-navigating-the-analytics+-toolbar/table-toolbar.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.