Pivot Tables and Pivot Charts

Pivot tables are used in IFS Business Reporter to display a graphical summery of an executed report. This can be used for a quick and easy analysis of the information available in an executed report. A Pivot table simplifies the arrangement report data in a flexible manner by filtering out unnecessary information.

The suggested method to use Pivot tables and Pivot Charts is given below:

• Create a Non-BR Sheet
  • This is done in Design Mode by using Design Sheet options.
  • Select the option to refresh the Pivot when executing the report.
• Create a basic BR design sheet where a two dimensional table with columns and rows is created using Business Reporter design. The columns should have column headers and the should be adjacent to one another.
• Run the report
• In the executed report, go to the Non-BR Sheet and create a Pivot table using Excel Pivot fuctionality. As a reference choose the table previosly created in design mode.
• Run the report again. The pivot table will show the data of the above referenced sheet. If the report has parameters the design sheet will generate different outputs depending on the supplied parameter value. Pivot table will be updated depending on the output in the referenced sheet.
• Once a Pivot Table gives the wanted output, a Pivot Chart can be created which refers to the above Pivot Table. It is recommended to create the Pivot Chart also in a Non-BR Sheet, either in the same sheet as the Pivot Table or in a separate sheet.