hI, i am trying to put the relative measure from a straight table into a pivot, the pivot has not the checkbox of relative and i need to do it in the expression I have 5 unique relations but one is having two campagnes, in the relative it's calcuted for that specific campagne as 1/6 is 17 % this is good, but if i do a count(distinct Relatie)/count (distinct total relatie) it's getting back with 1/5 20 % I need a formula which gives me the 17 %. Campagne,Sub,Relatie Z,Internet,123 Z,Email,456 Z,Email,678 A,Email,123 A,Internet,375 A,Internet,450 How can i solve this? see attached file with demo data Thanks helping me out. Linda
