Greetings,
Given my measure [Total Count Distinct] and the following dimensions:
Year = 2008F, 2009S, 2010F, 2011W
Courses: ART, ENG, MAT, and
On my report I would like to aggregate [Total Count Distinct] that is greater than 100 for each year and for the whole year.
1. When I set [Total Count distinct] > 100 in my query filter, I got blank report
2. I tried creating a variable:
my variable = ([Total Count distinct] >= 100) and when I placed my variable in the report, I got 1 for [Total Count Distinct] that are > 100 and 0 for the rest.
What would be the best way to accomplish this?
Regards,
OCM
Given my measure [Total Count Distinct] and the following dimensions:
Year = 2008F, 2009S, 2010F, 2011W
Courses: ART, ENG, MAT, and
On my report I would like to aggregate [Total Count Distinct] that is greater than 100 for each year and for the whole year.
1. When I set [Total Count distinct] > 100 in my query filter, I got blank report
2. I tried creating a variable:
my variable = ([Total Count distinct] >= 100) and when I placed my variable in the report, I got 1 for [Total Count Distinct] that are > 100 and 0 for the rest.
What would be the best way to accomplish this?
Regards,
OCM