Enumeration: PivotShowDataAs

GC.Pivot.PivotShowDataAs

indicates the pivot table show value as type

Table of contents

Enumeration members

• difference
• index
• normal
• percent
• percentDiff
• percentOfCol
• percentOfParent
• percentOfParentCol
• percentOfParentRow
• percentOfRow
• percentOfRunningTotal
• percentOfTotal
• rankAscending
• rankDescending
• runTotal

Enumeration members

difference

• difference = 8

Difference from

index

• index = 14

index

normal

• normal = 0

no calculation

percent

• percent = 4

% of

percentDiff

• percentDiff = 9

% difference from

percentOfCol

• percentOfCol = 3

% of Column Grand Total

percentOfParent

• percentOfParent = 7

% of Parent Total

percentOfParentCol

• percentOfParentCol = 6

% of Parent Column Total

percentOfParentRow

• percentOfParentRow = 5

% of Parent Row Total

percentOfRow

• percentOfRow = 2

% of row Grand Total

percentOfRunningTotal

• percentOfRunningTotal = 11

% of running total in

percentOfTotal

• percentOfTotal = 1

% of Grand Total

rankAscending

• rankAscending = 12

rank smallest to largest

rankDescending

• rankDescending = 13

rank largest to smallest

runTotal

• runTotal = 10

running total in