Amazon VBA Manual do Utilizador descarregar pdf (Página 28)

With PT.PivotFields(“Units”)

.Orientation = xlDataField

.Function = xlSum

.Position = 2

.NumberFormat = “#,##0”

End With

Chapter 11 Using VBA to Create Pivot Tables

258

Figure 11.12

The default pivot table

report has multiple data

fields as the innermost

column field.

Figure 11.13

By moving the data field

to the first row field,you

can obtain this view of

the multiple data fields.

Calculated Data Fields

Pivot tables offer two types of formulas. The most useful type defines a formula for a calcu-

lated field. This adds a new field to the pivot table. Calculations for calculated fields are

12_0789736012_CH11.qxd 12/11/06 6:26 PM Page 258

1 2 ... 23 24 25 26 27 28 29 30 31 32 33 ... 59 60

Sem comentários

Amazon VBA Manual do Utilizador Página 28