Adding a Pivot Table and a Chart

It is useful to export rows and rows of data on an Excel spreadsheet. However, the drawback is that adding charts turns data into information. With Pivot table, you can easily slice and dice the data for deeper analysis.

Moreover, Pivot table enables you to create simpler reports by exporting all the (raw) data in the report with a minimum number of filters on the Create report page. Then you can slice, dice, filter, and customize the data directly in Excel and view the result in real time without running the report again with a different set of filters.