Problem solved! 🙂

Here is the sql-statement that did the trick!

SELECT *, (ISNULL(Denmark,0) + ISNULL(Finland,0) + ISNULL(Lithuania,0) + ISNULL(Norway,0) + ISNULL(Sweden,0)) /

(CASE WHEN ISNULL(Denmark,0)>0 THEN 1 ELSE 0 END +

CASE WHEN ISNULL(Finland,0)>0 THEN 1 ELSE 0 END +

CASE WHEN ISNULL(Lithuania,0)>0 THEN 1 ELSE 0 END +

CASE WHEN ISNULL(Norway,0)>0 THEN 1 ELSE 0 END +

CASE WHEN ISNULL(Sweden,0)>0 THEN 1 ELSE 0 END) AS Total

FROM (SELECT DropRate,MarketingName, Manufacturer, Country FROM tblTest) s PIVOT (AVG(DropRate)

FOR Country IN ([Denmark], [Finland], [Lithuania], [Norway], [Sweden]))P

Many thanks to Visakh Murukes for the help!

Best // Thomas