How to use excel's getpivotdata function

How to use excel's getpivotdata function: 1. Open the form, enter the function [=GETPIVOTDATA("Purchase price")], and the purchase price is the query field; 2. Enter the data dialysis table area and quote it absolutely [= GETPIVOTDATA("Purchase price",$H$15)].

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to use excel’s getpivotdata function:

1. First open Excel and create a new table, as shown in the figure.

#2. Then enter the function =GETPIVOTDATA("Purchase price"), and the purchase price is the query field, as shown in the figure.

3. Then enter the data dialysis table area and quote it absolutely. At this time, the function is: =GETPIVOTDATA("Purchase price",$H$15), as shown in the figure.

#4. Then enter the field name. At this time, the function is: =GETPIVOTDATA("Purchase Price",$H$15,"Category"), as shown in the figure.

5. Then enter the field value. At this time, the function is: =GETPIVOTDATA("Price",$H$15,"Category","Keyboard"), such as As shown in the figure.

6. Finally, click the Enter key to get the result, as shown in the picture.

Related learning recommendations: excel tutorial

The above is the detailed content of How to use excel's getpivotdata function. For more information, please follow other related articles on the PHP Chinese website!