Find MAX, Average, and Median from Pivot Table Column based on 'Site' selection
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.
Re: Find MAX, Average, and Median from Pivot Table Column based on 'Site' selection
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1