I'm trying to use the Class function to show the count of client per representative, broken down by date. For example, I'm trying to show that in year 2009, 50 representatives had 3 clients, 24 representatives had 5 clients, and 17 reps had 6 clients. However, there are instances where a client will switch representatives over a year. Therefore, the class function isn't properly working when you drill down into the dates since it doesn't seem to take date into consideration.
My dimensions are Date and a calculated dimension of Aggr(Class(Count(distinct ClientNumber),1),[Representative Name]) and the expression is Count(distinct ClientNumber). Unfortunately I can't share data due to confidentiality, but is there any way of doing this better? Perhaps some sort of IF loop?