Cognos DMR Model Help

Here is an attachment and what I'm looking for is
"Number of districts below 25% turnover rate"

**Any further questions let me know please..
Thank you in advance
Who is Participating?
RWrigleyConnect With a Mentor Commented:
Assuming that the lowest level of your "Total" dimension is called "District", you should just need an expression like:

count(1 within set filter([MyCube].[Total].[Total].[District],[TurnoverRate] < 0.25))

But you may need to be careful depending on if your "turnover rate" is a database item or a calculation.
SunsetbloomAuthor Commented:
Here is a mock up chart what I'm supposed to create... I'm stuck as to how go about the total of my districts to display. The above chart is just a gist as to how my data looks
SunsetbloomAuthor Commented:
Earlier before posting this question, I used the exact expression like the one you have suggested... but it didn't work because I forgot to refer the lowest level data so used the descendants function.
Thank you so much for your prompt reply. :)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.