Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI
I've created a hierarchy based on Task ID
Hierarchy ( TaskId,TaskParentTaskId,TaskName,'ParentTask')
On the first level of the hierarchy there is an additional field that I could do with pulling down to all levels below it :
if(TagName = 'CME','CME',
if (TagName ='NPD', 'NPD',
if (TagName='Non-Contract Specific','Non-Contract Specific',''))) as ProjectType_TAG,
if(TagName = 'UK','UK',
if (TagName ='APAC', 'APAC',
if (TagName='RoW','RoW',
if (TagName ='Americas', 'Americas')))) as Region_TAG
This tag only appears on the 'parent' of the hierarchy (essentially I'm pulling through a task list - all the subtasks should have the same data but the source does not contain that). The TagName contains several key words so I'm only looking for specific ones.
In the example below anything with an xxx should contain the same data as the related TaskName e.g. Subtask1 should have the same Region_TAG as TaskName1 - is this even possible? At the moment I'm losing data in my charts if I try to filter on Region/project type tags which is understandable but I want both!
Task | ProjectType_TAG | Region_TAG |
TaskName1 | CME | UK |
Subtask1 | xxx | xxx |
Subtask1.2 | xxx | xxx |
TaskName2 | NPD | RoW |
Subtask2 | xxx | xxx |
Subtask2.1 | xxx | xxx |