I’m trying to create a running sum of issues created over time. As seen below, issues are split by Function (A or B) and Severity (High/Low). I need my running sum to be partitioned by Function and Severity, so at any point I have a count of the issues created in each Function/Severity combination. The table is color coded to show the rows that should be considered together.
Date
Function
Severity
Issues Created
Running Open Issues
1-Jan
A
Low
3
3
1-Jan
A
High
2
2
1-Jan
B
Low
4
4
1-Jan
B
High
1
1
2-Jan
A
Low
1
4
2-Jan
A
High
0
2
2-Jan
B
Low
1
5
2-Jan
B
High
1
2
3-Jan
A
Low
1
5
3-Jan
A
High
3
5
3-Jan
B
Low
0
5
3-Jan
B
High
1
3
I have searched extensively and unfortunately have not been able to get it working.
Primarily, I have tried: Aggr(RangeSum(Above(Sum(Issues Created),0,RowNo())), Function, Severity) , which returns nulls, and
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
