I would like to create a table that shows the following information.
Currently we have Tasks and under them sub-tasks are created for each team with Target start (current month +1). Each sub-tasks has their own statuses and component assigned. We would like to create a report that same format as below.
||Subtasks with Current month + 1 Target start status
||Subtasks with Current month + 1 Target start components
Sorry for not answering sooner.
To create the table, that has the tasks and subtasks in it, please choose the Issue dimension in rows, under “All hierarchy level members” choose Sub-task at the Parent level.
Then under the “Drill into or expand” choose Sub-task under Sub-task level.
This will create the structure, tasks, and sub-tasks under them:
To get the subtask’s status based on the Target start that falls into next month, please use the formula:
[Measures].[Issue target start],
Please double-check the Issue target start name to see if it’s correct.
And a similar formula to create the component’s column based on the Issue Target start instead of
[Measures].[Issue status] choose the
[Measures].[Issue component] .