Pivot Tables - Advanced Options

The Advanced Options allow you to customize the output and layout of the generated Pivot Tables.

1. Secondary Pivot

   The Secondary Pivot allows you to Pivot on more than one question. For example, if you wanted to produce a Pivot Table that pivots on Gender AND Race, you can choose Gender as the primary Pivot and Race as a the secondary pivot. The secondary pivot is optional.

2. Nested Pivot

   The Nested Pivot allows you to Pivot on more than one question combined. For example, if you wanted to produce a Pivot Table that pivots on Gender combined with Race, you can choose Gender as the primary Pivot and Race as a the nested pivot.

3. Data Table

   The values produced in the Data Table can either be absolute frequency numbers i.e. the actual number of users who chose a particular option, or be relative percentage.

4. Display Options

   The Pivot Tables can be generated with or without associated charts. Generating Pivot Tables without charts is generally faster and the resulting file is smaller also.