count(distinct SHORT_MBO_NAME) wouldn't help because if I do that, all the statuses will be counted as 1 each which is not true. There are 48 accounts in total and each account has 7 MBO's and I have data for 3 months. So total should come up to 48*3*7= 1008.
Good rule for the future is to name your forums with the specific question, so the next person with your problem can find the solution.
"Count the distinct of multiple fields" would be a good name - may want to change it