Forum Discussion

SakshiNijhawan's avatar
SakshiNijhawan
Frequent Visitor
5 years ago

Computing row-wise running/cumulative total in a matrix

Hi community members,

 

I am trying to calculate row-wise running total of principal balance in a matrix and then make a curve for the same. To achieve the same, for now, I have calculated 8 different measures. This solves the purpose of getting the row-wise running total but when I create a line chart for the same, it gives me 8 different curves. This works when I use a column chart but I want to be able to get only single curve based on the totals of the running total for those 8 categories.

 

For getting a single curve, I should be able to create a single column/ measure for the running total. The one that I have currently does not fill up blanks in the matrix. To solve the same, I have tried the following link: Link but with no success.

 

Any leads would be very helpful and appreciated.

 

Thank you!

Need Help

2 Replies

    • SakshiNijhawan's avatar
      SakshiNijhawan
      Frequent Visitor
      5 years ago

      Hi Amit,

      Pleasse find the sample output table attached. I am looking to find a row-wise cumulative total of principal balance for each month. Further, I am looking to do a sumproduct of the principal balance with each column value/category and divide the sumproduct by the sum of the principal balance. The formula is mentioned in the image for your reference.

       

      These calculated values using sumproduct are the ones that I need to use for my curve that I mentioned in my post.

       

      Let me know if you have any more questions.

       

      Thanks,

      Sakshi