6 Replies Latest reply on Aug 18, 2016 6:57 AM by Jakob Sebens

# Totals per year, summed per year

Hi All,

I have been reading the forums for quite some time, and i value the community and the solutions given by all community members. But, here i got my own challenges to work out.

I created a text report with in the columns the date (Years, quarters) and in the rows the orders and the description of the orders. It will give me an overview of the amount of orders per timeperiod. I want to add a number, that represents the total of all orders in a year up to a certain year. So if in 2011 it where 5 orders, in 2012 it where 3 orders, the total in year 2012 should be 8, and not 3. So i want a total up to year. The amount of orders happened in year 2012 should be counted with the orders of year 2011, and if we got 4 orders in 2014, the total in the 2014 column should be 5+3+4=12, and for 2014 we got 1 order so 5+3+4+1=13 orders and so on.

I hope you guys can help me since i have absolutely not clue on how to do this. I've made some calculated fields already but they dont seem to generate what i want.

Thanks!

Jakob

(This is how i want to see it, preferably, The original value + total for the years)

• ###### 1. Re: Totals per year, summed per year

I guess using RUNNING_SUM() you can achieve that. It'll be more helpful for us to give you desired solution If you share a sample workbook in .twbx format.

Mahfooj

1 of 1 people found this helpful
• ###### 2. Re: Totals per year, summed per year

Hi, Thanks you for your response, i will pack a workbook with some dummy data and upload it.

• ###### 3. Re: Totals per year, summed per year

Right Click on Sum([Number of Record]) > go to quick table calculations and select Running Total

This should sum the numbers as you require

2 of 2 people found this helpful
• ###### 4. Re: Totals per year, summed per year

Hi Khalid,

Thank you very much for your answer. I created the numbers as i want, but i want a slight change:

For now i see two numbers: Amount of orders per year (for each year) And a running total that will add each years total which is perfect! Is there a possibility to tell how many orders there where per month and make the running total to only count per year? The report will look like this:

January, Februari, March, April, May, June, July, August, September, October, November, December, Running Total (sum of everything till this moment (end of year total))

5               8            7          3       9       12     2       43        34               16          45               10              184

• ###### 5. Re: Totals per year, summed per year

The easiest way to achieve this would be to do months and the yearly total on separate sheets and place them together on a dashboard.

1 of 1 people found this helpful
• ###### 6. Re: Totals per year, summed per year

Hi Khalid,

Thank you kindly for your suggested solution, it is not quite what we want since the report is going to be really long, so it is going to be scroll-able. I will implement the suggested solution for now, and improve it whenever we got the knowledge to do so.

Thank you again,

Jakob