I want to count all rows. Distintcount works but when it comes down to sub total, if there is no value, it does not include the particual row.
Let's say: Project A for c person has not got a value. So when I use distintcount (level), it won't add C in Project A/Count in green. I need the High total for Project A/count in green should be 3 not 2. Regardless of the values, it just needs to count the total rows per level. Has anyone got an idea?
<tbody>
</tbody>
Let's say: Project A for c person has not got a value. So when I use distintcount (level), it won't add C in Project A/Count in green. I need the High total for Project A/count in green should be 3 not 2. Regardless of the values, it just needs to count the total rows per level. Has anyone got an idea?
level | Staff | Project A /value | Project B /value | Project A /count | Project B/count |
high | a | 2 | 45 | 1 | 1 |
b | 10 | 25 | 1 | 1 | |
c | 10 | 1 | |||
High Total | 12 | 80 | 2 | 3 |
<tbody>
</tbody>