Edit Data in Pivot Tables

<< Click to Display Table of Contents >>

Navigation:  Version 6 Enhancements > Enhanced Data Analyzer > Pivot Table / Analyzer User Interface > Data Editing >

Edit Data in Pivot Tables

 

Edit Cell Values

To edit a cell value, click the cell and specify a new value:

img12052

Cell values are specified via editors of different types (e.g. text editor, calculator, etc.), depending on the cell data type and pivot table settings.

Edit Expressions

Specific columns allow you to set a regular or Boolean expression which will be used to calculate their values. Clicking the column header invokes the Expression Editor used to specify the expression:

img12051

To learn more about using the Expression Editor, see Expression Editor.