Create a drop-down list in cell B14 and cell B15 to quickly select the first and second item (see downloadable Excel file).ħ. Note: this GETPIVOTDATA function has 6 arguments (data field, a reference to any cell inside the pivot table and 2 field/item pairs). The dynamic GETPIVOTDATA function below returns the amount of mango exported to Canada. Note: the GETPIVOTDATA function returns a #REF! error because the value 680 (beans to France) is not visible.Ħ. For example, use the filter to only show the amounts of fruit exported to each country. The GETPIVOTDATA function can only return data that is visible. ![]() Note: the GETPIVOTDATA function correctly returns the amount of beans exported to France.ĥ. Again, use the filter to only show the amounts of vegetables exported to each country. ![]() ![]() Note: Excel automatically inserts the GETPIVOTDATA function shown above.Ĥ. ![]() Select cell B14 again, type an equal sign (=) and click cell D7 in the pivot table. Note: cell B14 now references the amount of carrots exported to France, not the amount of beans. Use the filter to only show the amounts of vegetables exported to each country.
0 Comments
Leave a Reply. |