dixiebritt
Board Regular
- Joined
- Jan 8, 2014
- Messages
- 63
Quarter | SR | Client |
q1 | jane | abc company |
q1 | jane | mcg inc |
q1 | jane | mcg inc |
q1 | house | box llc |
q1 | bob | hti |
q2 | bob | hti |
q2 | bob | apple |
q2 | jane | abc company |
<tbody>
</tbody>
I have this set of data. I want to do two things:
1. calculate the number of total unique clients by Quarter and SR
2. calculate the number of total unique clients by Quarter only