Microsoft Office Tutorials and References
In Depth Information
Figure 18-43: After expanding the pivot table, formulas that used the GETPIVOTDATA function continue to dis-
play the correct result.
Using the GETPIVOTDATA function has one caveat: The data that it retrieves must be
visible in the pivot table. If you modify the pivot table so that the value use by
GETPIVOTDATA is no longer visible, the formula returns an error.
Search JabSto ::




Custom Search