Hey guys,
I have this table below:
And what I am trying to do is I want it to show the total amount for the entire table on the row of jan 2018 and then as the total amount grows I want the next total amount on 2018 februar etc. as it goes.
The key here is that I want to know what is the total of amount today. And then I want to see what is the total amount at that day and be able to see the development on a line chart.
Is this something that I can solve / calculate front-end or would it best to make an aggregated table in the script and have that on the side?
Any suggestions is welcomed!
Try sthing like this:
if(Capitalize(Month)='Jan',sum(total {<Month>} Amount), sum(total {<Month>} Amount) + RangeSum(above(sum( {<Month>} Amount),0,RowNo()-1)))
and tell me what happens
Per analogy the result would be :
Don't mind the numbers. I am changing them as we go, but you can see the logic. Is this really possible to be honest? Because I have a total which is X in January, and in February they might have sold more so the total amount would be X more than the previous X amount and I don't have that value stored anywhere.
Let me try.
Look at following picture:
So you can see there are two different campaigns. These campaigns have a total value, but are distributed throughout the year. So On the first of January the total sales is 795 because there was only campaign 1 active. Then campaign 2 became active and that also distributes an amount throughout the year, but now the total sales that we have on that day is the total amount on that date.
Gives an idea of sales rate.
Ok.
Let me try another explanation.
Lets say you write down how much did your company have in total sales today.
Then you next week write down how did the company have in total sales that day.
And then you put that in a line graph.
Makes sense 
?
