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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |