5 Replies Latest reply on Aug 24, 2016 4:20 PM by Thomas Dodds

    Using running sum

    Wolfrm

      I have a table that has months as columns, and the years (past 5 years) as rows.

       

      I would like the table to display the running sum after each month. It should do this for each of the five years, and of course the rows (years) should be independent of each other. Grateful for any help you can provide.

        • 1. Re: Using running sum
          Thomas Dodds

          2016-08-23 10_48_19-Oracle BI Answers.png

          Works in pivot too ... the sample I have doesn't have the month number by itself, so the pivot isn't the way to show it, but I'm assuming your year is YYYY and your month is MM only.

          1 person found this helpful
          • 2. Re: Using running sum
            Wolfrm

            Thanks for this example, Thomas, however I would need the months to be columns, not rows. This is so I can visually compare March this year, to March of last year, for example.

             

            Something like this:

             

             

            My database also has the months in YYYY/MM format, so I have to do some conversions to get it to display as above.

            • 3. Re: Using running sum
              choracy69

              Hi Wolfrm,

               

              If youwant compare for example March for each year you can create something like that:

               

              First table it's simple pivot table with row and column grand total. The measure column i RSUM(allocated_hours).

              The second table it's simple pivot with 2014,2015,2016 and simple measure column (without RSUM) and Calculated Item: test.

               

              For this you must creation Selection Step:

               

               

              1 person found this helpful
              • 4. Re: Using running sum
                Gianni Ceresa

                Take what Thomas did, use a pivot view instead of table, add months as columns and keep years as rows => done

                1 person found this helpful
                • 5. Re: Using running sum
                  Thomas Dodds

                  "Works in pivot too ... the sample I have doesn't have the month number by itself, so the pivot isn't the way to show it," ...

                  1 person found this helpful