Avatar of Sunsetbloom
Sunsetbloom
Flag for United States of America asked on

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
Untitled.png
DB Reporting Tools

Avatar of undefined
Last Comment
Sunsetbloom

8/22/2022 - Mon
Sunsetbloom

ASKER
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
Untitled2.png
ASKER CERTIFIED SOLUTION
RWrigley

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Sunsetbloom

ASKER
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. :)
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes