I have a table with 2 columns 1 column lists multiple entries of different supplier names can be duplicate names in the column. the second column lists an outcome 1 of 4 outcomes.

In a pivot table i want to create a formula that calculates the % of one of the 4 outcomes as of the total outcomes for a particular client.

I know how to do the formula in a worksheet would be =countif(X=1)/count(X)

the syntax is killing me please help

Cheers Matt