Cell = PivotTable Formula

September 10, 2020 at 13:37:24
Specs: Windows 10
I have a PivotTable with 10 individuals and their scores every week in Sheet2 with a slicer to filter the average score of those who are with Team Red and Team Blue. I need a formula in Sheet 1 in B2 to get the average score of Team Red, B3 to get the average score of Team Blue and B4 to get the average score of all participants. Is this possible?

1   Team        Score
2  Team Red      96%
3  Team Blue     96%
4  Total	 96%


message edited by CuriousChris


See More: Cell = PivotTable Formula


#1
September 13, 2020 at 21:48:50
If the pivot table looks always like in your example, meaning that in Sheet2 Team Red score is in B2, Team Blue in B3 and Total in B4, in Sheet1 you could write exactly that:
B2=Sheet2!B2
B3=Sheet2!B3
B4=Sheet2!B4

Or you could extract the percentages based on the source of the pivot table with a longer formula.


Reply ↓  Report •
Related Solutions


Ask Question