Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there
I want to create a chart as per the below, I have the user, date and the volume per day.
But in the MTD column I need to have 61+71 in row 2 for example.
In row 3 its the sum of 71+61+75 and so on.
Is this possible?
I have tried above and below functions but cannot seem to achieve this.
Thanks,
Aidan
User | Date | Volume | Total MTD |
User 1 | 01/11/2015 | 71 | 71 |
User 1 | 02/11/2015 | 61 | 132 |
User 1 | 03/11/2015 | 75 | 207 |
User 1 | 04/11/2015 | 56 | 263 |
User 1 | 05/11/2015 | 55 | 318 |
User 1 | 06/11/2015 | 74 | 392 |
Try with
=RangeSum( Above( Sum(VolumeField), 0, RowNo() ))
Or may be this:
=RangeSum(Above(TOTAL Sum(VolumeField), 0, RowNo(TOTAL)))
Hi Sunny
That's great, only thing is if I wanted it to reset at each new row fro example below;
User | Date | Volume | Total MTD |
User 1 | 01/11/2015 | 71 | 71 |
User 1 | 02/11/2015 | 61 | 132 |
User 1 | 03/11/2015 | 75 | 207 |
User 1 | 04/11/2015 | 56 | 263 |
User 1 | 05/11/2015 | 55 | 318 |
User 1 | 06/11/2015 | 74 | 392 |
User 2 | 01/11/2015 | 40 | 40 |
Thanks again for your help
AIdan
Hi,
you can use the following expression in your query:
LOAD ...
[Volume] + if(isnull(Peek(acc_volume, -1)), 0, Peek(acc_volume, -1)) as acc_volume
from ...;
That's why I left out the TOTAL qualifier.
Perfect thank you