You need to calculate your averages using a GROUP BY and then add these back to your PIVOT.
Here's a start on your sample data: "snip"
SELECT Country, Manufacturer, MarketingName, AvgDropRate=AVG(DropRate)
FROM @Phones
GROUP BY Country, Manufacturer, MarketingName
Thank´s dwain! Will start with this 🙂
Best // Thomas