Contextures

Pivot Power Premium Help Pivot Table

This page shows how to use the main features of the Contextures Pivot Power Premium add-in. If you have a question that is not answered here, send an email to
Debra Dalgleish -- ddalgleish @ contextures.com

NOTE: This page is under construction -- more information will be added soon.

Back to Help Page

Pivot Table

Change pivot table settings, create info lists, build or update pivot tables from field lists.

Pivot Tables Commands

Watch this video for a quick tour of the Workbook commands on the PPP tab in Excel.

NOTE: the Pivot Table Builder commands are show in separate videos, below.

Video Timeline:

  • 0:00 Introduction
  • 0:17 Pivot Table Settings
  • 2:46 Pivot Table Info
  • 6:25 Totals

Pivot Table Builder

PT Builder Field List - From Pivot

This video shows the steps for creating a field list from an existing pivot table. Then, the field list settings are changed, and the original pivot table is updated, based on the new settings.

PT Builder Field List - From Table

This video shows the steps for creating a calculated field in a PT Builder field list. Then, update a pivot table to add or update the calculated field.

0:00 Build Field List from Source Data

1:38 Create a New Pivot Table

3:03 Naming Sheets and Field Lists

PT Builder Field List - Calculated Field

This video shows the steps for creating a field list from a named Excel table. Then, the field list settings are changed, and a new pivot table is created, based on the field list settings.

0:00 Create a Simple Calculate Field

1:45 Update the Pivot Table

2:31 Revise a Calculate Field Formula

Last updated: January 10, 2019 2:40 PM