Not sure I understand the problem. A pivot table, if you use Count of
Risks, will consolidate those multiple entries. What do you mean you
"won't get a result"?

When I use the data you gave, with OrgUnitName in the column field,
RiskName in the Row field, and Count of RiskName in the Data field, I
get exactly the result table you indicate.

In article ,
Marc Bucher wrote:

Thanks for this. I tried to use a Pivot instead of the source table, but the
problem is that I can have multiple entries for a certain risk and ou (cf.
rows 1 and 2) where I still won't get a result.

Any other idea?