Cumulative Items Sold MTD

[rammarthi]

Hi,

Please help me with populating cumulative Items sold when we have an item id, date and number of items sold per day.

Please note that every month the cumulative sum should start afresh as shown in the attached file. 

Appreciate it, if you can give it for both front end charts and scripting.

[Vegar · Accepted solution]

To get the values in the script try concerning like this:

Load
Emploee ID,
Date,
Items sold,
If( monthname(peek('Date'))=monthname(Date),
peek('Cumulative MTD') + [Items sold],
[Items sold]
) as [Cumulative MTD]
Resident source
Order by Date ;

[rammarthi]

How can we do this in front end?