Pivot Table Editor

Top  Previous  Next  

The Pivot Table editor window allows you to specify the appearance and behaviour of pivot tables that have been added to your dashboard tabs.

 

A pivot table is a tabular representation of data that can automatically sort, count, total or give the average of data quickly creating unweighted cross tabulations.

clip638

 

The Pivot Table editor window consists of the following tabs;

Data

Allows you to define the data that will populate the pivot table.

Totals

Allows you to specify if totals are included in the pivot table, and how they are calculated.

Appearance

Allows you to specify settings that will govern the appearance of the pivot table.

Numeric Format

Allows you to specify the numeric format used to display numbers in the dashboard object.

Font

Allows you to specify the font used to display data in the pivot table

Drill Down

Allows you to add and define a drill down for the pivot table

Alerts

Allows you to define alerts for your pivot table


Copyright © 2003-2017 DataPA Limited, all rights reserved. DataPA OpenAnalytics 6.0