# Basic Reporting

To create a simple report, add a field to the PivotTable by ticking the check box beside the field name in the PivotTables Fields pane.

Selected fields are placed to their default areas: non-numerical fields are added to Rows, date and time hierarchies are added to Columns, and numerical fields are added to Values.

Drag the field to move it to another area

Excel: PivotTable Fields

Excel: PivotTable Fields

Click the funnel icon beside a value to sort and filter.

Excel: Filters

Excel: Filters

To create a chart corresponding to the existing PivotTable, select the PivotTable or any cell inside the PivotTable, then go to the Insert tab and select the chart type.

We value your feedback!

Please take a few minutes to complete our survey and share your thoughts on your recent experience with our documentation.

Take survey

Close