Problem for consolidating data

Hello,

I'm trying to have a consolidate results but I have difficulties to do it.

My database is the following:

Sub entity           Code          Coverage

Sub entity 1         01            Covered

Sub entity 2         01            Covered

Sub entity 3         01            Covered

Sub entity 1         02            Partially

Sub entity 2         02            Covered

Sub entity 3         02            Covered

Sub entity 1         03            Not covered

Sub entity 2         03            Not covered

Sub entity 3         03            Not covered

When I build a chart per sub entity representing the number of codes per coverage, I have no problem. However, if I select all the sub entities, I would like to have a consolidate view taking into account the following rules : if all are covered then it is covered, if all are not covered, then it is not covered, otherwise, it is partially covered.

Sub entity           Code          Coverage

Entity                   01            Covered

Entity                   02            Partially

Entity                   03            Not covered

I'm not sure about what I need to do (creating a column or a measure).

Could you help with this issue?

Jérémie