Creating a Pivot Report

To view how to add ‘Open Report’ tile on home screen click ‘Here’

Step 1: Add a New Pivot Report

2
Click on your newly added ‘Open Reports’ tile (1) to open the reports section.

3
Click on ‘Add New Report’ (1) to proceed to Report Editor Form.

mod
Click “No” to create a Pivot Report.

Step 2: Select Data to Analyze

5
Above is the Report Editor Form. Here you can create reports and save them. Choose the data sample that you want to analyze from the drop down list (1).

Step 3: Selecting Fields to populate Report

6
After selecting the data sample:

  1. Select the fields that you want appearing in your report.
  2. Drag fields in either of the four areas ‘REPORT FILTER’, ‘COLUMN LABELS’, ‘ROW LABELS’ and ‘SUMMARY OF VALUES’
  3. As you drag and place the fields to these areas, your report will start to generate and will appear on the left side.

Step 4: Adding Charts and Graphs

7
You can also add various charts and graphs in your report.

  1. Select the type of chart you want to add
  2. The chart will appear below your report

If you wish to know more about charts press here

Step 5: Naming and Saving your Report

8
To rename your report:

  1. Click the ‘Edit’ button to change your report name and description
  2. Enter report name and description
  3. Click OK to save your changes

9
Click the ‘Save’ button (1) to save your report. A message (2) will pop up to confirm the report has been saved.

Step 6: Making a Report ‘Public’

10
In order to make your report ‘Public':

  1. Click the ‘Version’ button
  2. Select your report name
  3. Click the ‘Public’ button


Click Yes (1) to set your report public.

12
Your created report will appear in the Reports section (1). You can click on it to open your report.

To make a “List” report ‘Press here’
To know the difference between “Pivot” and “List” reports ‘Press here’