Hi ,
I have a measure having following code
pick(match(valuelist('Assessment/Screening','Education-HealthCondition','Relationship','Behavior','ManagementofCare',
'CommunityResources','Navigation','Specialty','Mood','Anxiety','Depression','SleepConcerns',
'PTSD','ADD/ADHD'),
'Assessment/Screening','Education-HealthCondition','Relationship','Behavior','ManagementofCare',
'CommunityResources','Navigation','Specialty','Mood','Anxiety','Depression','SleepConcerns',
'PTSD','ADD/ADHD'),
sum([PBAS-SupportAssmt/Screening]),
sum([PBAS-EducationHealthCondition]),
sum([PBAS-Relationship]),
sum([PBAS-Behavior]),
sum([PBAS-SupportManagementCare]),
sum([PBAS-LinkCommunityResources]),
sum([PBAS-SupportNavigation]),
sum([PBAS-LinkSpecialty]),
sum([PBAS-SupportMood]),
sum([PBAS-SupportAnxiety]),
sum([PBAS-SupportDepression]),
sum([PBAS-SupportSleepConcerns]),
sum([PBAS-SupportPTSD]),
sum([PBAS-SupportADD/ADHD])
)
In another graph I want to pick only top five value list items (which will dynamically change over the time). Also I want to use my fiscal year dimension instead value list dimension. Can any body help please.
