Accumulation in matrix

Last post 08-19-2008 7:28 AM by aspneto. 1 replies.

Sort Posts:

  • Accumulation in matrix

    08-19-2008, 6:01 AM
    • Member
      163 point Member
    • aspneto
    • Member since 05-23-2006, 4:42 AM
    • Posts 128

     Hello,
    Is there a way to do a matrix that will
    accumulat my resoult?

    for example:
    I have month 1 with value 1
    month 2 with value 2
    month 3 with value 3 and so on.

    In the matrix I want to get for month 1 the value 1. for month 2 the value 3 (the sum of month 1 and 2) and for month 3 the value 6 (month 1 + 2 + 3).

    I know that I can get the value from row above with "previous" function but I need here the previous column.

    Thanks.

    Adopt a friend -
    http://www.friend.co.il
    The Israeli portal for adopting pets
  • Re: Accumulation in matrix

    08-19-2008, 7:28 AM
    Answer
    • Member
      163 point Member
    • aspneto
    • Member since 05-23-2006, 4:42 AM
    • Posts 128

     I got the solution on another forum from a user named bsmitha  :

    =Runningvalue(Fields!<Field>.Value,Sum,"<Matrix_GroupName(Row/Column Grouping)>")


    Thanks.

    Adopt a friend -
    http://www.friend.co.il
    The Israeli portal for adopting pets
Page 1 of 1 (2 items)