Hi there,

Thanks again for your feedback, but this is not what I am looking for,
because I do not want a count on risk name per OUName. Maybe the example is
not clear enough, but what I am trying to get is a formula that returns a
value of either 0, 1 or 2 in the different cells within the matrix. 0 means
OU has no risk allocated, 1 means OU has a certain risk allocated, but no
control with a "Low" flag and finally, 2 means that OU has a risk allocated
and at least one ControlFlag with "Low" (i.e. if there are five controls for
one risk in one OU and one risk has a control with a flag "Low" the value in
the cell should be a 2).

Hope it is clearer now what I am trying to get.

Thanks!

"JE McGimpsey" wrote:

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?