Microsoft Office Tutorials and References
In Depth Information
data_field is the name, enclosed in quotation marks, for the field of
data that you want to retrieve.
pivot_table is any cell or range of cells in the pivot table, which
tells Excel which PivotTable report to use.
field1, item1, field2, item2… are matched pairs of field names and
item names that describe the data you want to retrieve.
The alternate form is…
GETPIVOTDATA(pivot_table, name)
…where…
pivot_table, as in the first version, is any cell or range of cells in
the pivot table, which tells Excel which PivotTable report to use.
name is a text string that describes the data you want to
summarize, as the following examples illustrate.
Note that this version returns an error value if two different fields
have members with the same name, and you use one of those
names with this version of GETPIVOTDATA.
The following examples illustrate both variations.
Suppose this table contains raw data
to report. We easily can use the
PivotTable Wizard to create a
PivotTable report, as shown on the
next page.
A
B
C
D
1
2
3
4
5
6
7
8
9
10
11
12
13
Month
Division
Acct
Amount
1/1/2005
A
100
553
1/1/2005
A
200
714
1/1/2005
A
300
6
1/1/2005
B
100
430
1/1/2005
B
200
729
1/1/2005
B
300
246
2/1/2005
A
100
670
2/1/2005
A
200
64
2/1/2005
A
300
799
2/1/2005
B
100
948
2/1/2005
B
200
563
2/1/2005
B
300
884
Search JabSto ::




Custom Search