Greetings,
I need help writing a getpivotdata formula that will find the Max, Average, and Median (on the 'Site' tab cells B3:B5 respectively) for a series of numbers in the 'Days M6' pivot table column.
Ideally, I need cells B3:B5 to automatically display these data based on the Site selected from cell B8.
Bookmarks