# 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.](https://docs.inforiver.com/analytics+/working-with-analytics+/5.-tables/5.5.-formatting-data)

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FPm3aOsEvxuXY1mrq7jTu%2Fimage.png?alt=media&#x26;token=5282ce6d-b031-4bb3-929e-08a3b78470a9" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fw7NMBzRCmqiVpybrZmGd%2Fimage.png?alt=media&#x26;token=d45da01c-95b9-4f2d-9868-970a954a22b2" 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.](https://docs.inforiver.com/analytics+/working-with-analytics+/5.-tables/5.5.-formatting-data)

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F9BsX0Lwhe8p5oZTgdlu5%2Fimage.png?alt=media&#x26;token=f7494d25-2fad-4242-8eaf-d8f73c6d687a" 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.](https://docs.inforiver.com/analytics+/working-with-analytics+/5.-tables/5.6.-number-formatting)

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fer65KTF1vNFfFNkYFwtY%2Fimage.png?alt=media&#x26;token=10677c91-ae6b-47f0-aff0-3f7483cd29d8" 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.](https://docs.inforiver.com/analytics+/working-with-analytics+/5.-tables/5.7.-inline-charts)

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FmnODc0a3Z8hPPNekiwmd%2Fimage.png?alt=media&#x26;token=94316fa3-759d-4c33-8269-e45174c22c23" 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.](https://docs.inforiver.com/analytics+/working-with-analytics+/6.-trellis-customizations)

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FzxYjra5POiylEQqFWREM%2FTable%20trellis.gif?alt=media&#x26;token=a04be17f-8de1-40af-9e80-542b89463f49" 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.](https://docs.inforiver.com/analytics+/working-with-analytics+/7.-customize-measures/tables-measure-series)

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FbUkm5XADmG0akfX8Ytfr%2Fimage.png?alt=media&#x26;token=d506db57-6638-4baa-9bb6-f99b15d6b099" 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.](https://docs.inforiver.com/analytics+/working-with-analytics+/8.-splitting-and-grouping-measures)

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F36R4eKhHn1dUv8FdOowj%2FSplitMeasures.gif?alt=media&#x26;token=f7203351-7081-4936-9522-16fdc7d214f9" 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](https://docs.inforiver.com/analytics+/working-with-analytics+/9.-conditional-formatting).

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fq6VjKOrt91fRio5SLaYT%2Fimage.png?alt=media&#x26;token=53e95b6f-b0b5-4ff3-a6b5-f073b8043ac1" 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.](https://docs.inforiver.com/analytics+/working-with-analytics+/10.-sort-and-reorder-data)

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FDJF27QSkhonexHfgdLdP%2Fimage.png?alt=media&#x26;token=0cb25831-d935-4dc8-bd51-92c58b09eb24" 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](https://docs.inforiver.com/analytics+/working-with-analytics+/11.-ranking-data-topn).

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FItXVJLxvYmwrlvdzxnDm%2Fimage.png?alt=media&#x26;token=191bcf12-83f4-403a-b3e5-afa7f70098d7" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FTBVPPagw25977VtftnjD%2Fimage.png?alt=media&#x26;token=ee265bad-8eb1-4170-a8e1-69161c4bdb07" 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](https://docs.inforiver.com/analytics+/working-with-analytics+/5.-tables/5.8.-blend-measures).

  <figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FXKqfxWGE7eUEXO2Whpm9%2Fimage.png?alt=media&#x26;token=9339542d-c8a7-4d2a-8672-781482129d75" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FDYvzNSQscU8jX5GaDn2S%2Fimage.png?alt=media&#x26;token=bdb1893f-5bc4-4200-b8de-2ecd7b794b50" 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="../2.-data-management">Pivot data</a> window.</li></ul></div>

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F1Dm2mwO3BLATMxALfrpN%2Fimage.png?alt=media&#x26;token=73728c9c-4a23-4e3e-b2ef-4728ac64d6ea" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FkyDl2zqfAI31v1T4u6Kh%2Fimage.png?alt=media&#x26;token=044373e4-07c2-4b75-b376-7479975b6a8a" alt="" data-size="line">icon from the pivot data window to modify the formula.

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FVH0iptpxbQLmN6SQ243K%2Fimage.png?alt=media&#x26;token=4ac931fd-f83a-4b71-9d72-e426ef547f9c" 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.](https://docs.inforiver.com/analytics+/working-with-analytics+/12.-adding-notes)

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FUw4QT4fxjcitSAbmb535%2Fimage.png?alt=media&#x26;token=90376570-d7db-4020-9a41-565f42d97a76" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F9IXzpatI1YxTUxQJhoo0%2Fimage.png?alt=media&#x26;token=1b68cb72-77ad-4eb2-9cc6-032f44bd3b78" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F6zv6jNyy60l65H0q29C2%2FUntitled%20Project.gif?alt=media&#x26;token=0dbcb2db-865e-49fe-b5bd-bc20c597c93a" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Fv7gyIi6FppLm30im4UML%2FUntitled%20Project726e01.autosave.gif?alt=media&#x26;token=20b124a8-b19f-4602-954f-4a459b525feb" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2Ffw7i5sTCz7SXUfB4mpwM%2Fimage.png?alt=media&#x26;token=0ac628ca-5ef1-4437-af0c-da25ef96665a" 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="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2F0JUnYaI8Z2nGpNWzK31G%2Fimage.png?alt=media&#x26;token=d8dc8ced-04f5-4834-89a2-61c3105a591f" 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.](https://docs.inforiver.com/analytics+/working-with-analytics+/16.-backup-and-restore)

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

<figure><img src="https://3132984990-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbOoZhPvC57Z0CNgep4Ib%2Fuploads%2FZFBxIMgsmcCqtIxvKa1Z%2Fimage.png?alt=media&#x26;token=bd4b6c80-6552-4608-9abc-190a9615db85" alt=""><figcaption><p>Backup and restore</p></figcaption></figure>
