Hello Thauany Moreira, 

Documentation for Pivot table component.

It's available in the component documentation tab.

This is an example of how to use the pivot table with a relational database.

Step1: Setup  the Northwind Database. 

In this case I've added the external database with the Integration Studio. (You can use normal OutSystems entities)

Then add it as a dependency of your project 

Your database should look like this:

Step2: Install the Pivot table component and add it as dependency of your project:

For this example I've chosen the following elements:

Step3: Create a new screen, name it Pivot Table. 

3.1. Prepare this data (if you are working in Traditional):

The Aggregate should look like this:

3.2. Drag the Pivot Table Widget to the screen:

Assign the OrderDetailTable.Id to the SourceTableWidgetId.

The OnNotify is mandatory: this action refreshes the Pivot widget.

You can also drag a ShowHide block but is optional.

4. In your Browser, go to the Pivot Table web page.

You can now start drilling down the data with a pivot table by:

4.1. dragging the available entities to the greyed column or row areas;

4.2. selecting the chart type;

4.3. selecting the aggregation (COUNT, SUM, etc.);

4.4. a new input box appears: now choose the aggregated variable (eg. sales, discounts).