Microsoft Office Tutorials and References
In Depth Information
This is a PivotTable report
based on the previous
Excel table. The following
formulas illustrate ways to
return data from this report.
For clarity, I’ll label the two
versions of the function:
A: =GETPIVOTDATA(data_field, pivot_table, field1, item1, field2,
item2,...)
B: = GETPIVOTDATA(pivot_table, name)
A: =GETPIVOTDATA("Amount",$A$3)
B: =GETPIVOTDATA($A$3,"Grand Total")
B: =GETPIVOTDATA($A$3,"Amount")
B: =GETPIVOTDATA($A$3,"Sum of Amount")
All versions return 2806, the Grand Total for the PivotTable report.
A: =GETPIVOTDATA("Amount", $A$3, "Month", "2/1/2005")
A: =GETPIVOTDATA("Amount", $A$3, "Month", "2/1/2005",
"Division", "A")
B: =GETPIVOTDATA($A$3,"2/1/2005")
B: =GETPIVOTDATA($A$3,"2/1/2005 A")
All return 1533, which is Division A’s total for 2/1/2005. Specifying
page fields (here, the Division code) is optional for either the A or
B variation.
A: =GETPIVOTDATA("Amount", $A$3, "Month", "2/1/2005",
"Acct", "200")
B: =GETPIVOTDATA($A$3,"2/1/2005 200")
Both return 64.
A: =GETPIVOTDATA("Amount",$A$3, "Acct","200")
B: =GETPIVOTDATA($A$3,"200")
Both return 778.
Search JabSto ::




Custom Search