Cumulative sum of calculated measure for tasks grouped by Epic

Questions & Answers
, ,
5

Hi, @jakedatreble

The formula I gave you is for the Project and Epic levels using the Issues dimensions hierarchy level - Epic. If you need to go down one level, the next level is “Parent”. See the picture below:

Screenshot 2023-11-13 at 15.33.20
Screenshot 2023-11-13 at 15.33.201096×1242 102 KB

In my example, I’m creating the cumulative sum for the: Project, Epic, and Tasks using measure to sum - Issues created. Please replace the Issues created measure with the correct one (“Categorized Total Cost - All T-Shirt Sizes”):

CASE WHEN
[Issue].CurrentHierarchyMember.level.name = "Parent"
THEN
CumulativeSum(
[Measures].[Issues created]
)
WHEN
[Issue].CurrentHierarchyMember.level.name = "Epic"
THEN
CumulativeSum(
[Measures].[Issues created]
)
WHEN
[Issue].CurrentHierarchyMember.level.name = "Project"
THEN
CumulativeSum(
[Measures].[Issues created]
)
END

Kindly,
Ilze
support@eazybi.com