• 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