TrimMean of Pivot Table data sets

I'm extremely new to this forum, so forgive me for putting this in the wrong section.

I have uploaded my Excel Worksheet, so here is a breakdown of what I am trying to do:

In the Final Tally worksheet, I would like B2 to look for Jeff in my Pivot Table, pull the Burger data set for all weeks in Jan and Feb (B7-K7), and create a 30% Trimmean of the data. Then in B3, do the same thing for Joe, and B4 for John. I would also like the Final Tally to calculate while allowing expansion on the Pivot Table (Mar, Apr, May, etc.)

I hope I explained that correctly.

I have tried VLOOKUP. I have tried GETPIVOTDATA. I just can't seem to get what I need, while also allowing the columns to grow going forward.

Any help with this would be greatly appreciated. Thank you in advance.

Hi,

You can obtain these results directly from the source data, rather than from the pivot.

In B2 enter this array formula and copy across and down as required:

=TRIMMEAN(IF('Pivot Source'!$A$2:$A$31='Final Tally'!$A2,INDEX('Pivot Source'!$A$2:$F$31,,MATCH('Final Tally'!B$1,'Pivot Source'!$A$1:$F$1,0))),0.3)

Regards

This sounds like you somehow missed the large, emboldened array part of my original post. I trust you know how to enter these type of formulas in Excel?

Regards

You're welcome.