Cumulations and data selections

[michael089]

Hello,

I have the following issue which I cannot seem to solve. I have the following table:

MyTable:

LOAD * INLINE [

Date, Host, Recent, OS

2018-04-01, HostA, True, Win

2018-04-02, HostB, True, Win

2018-04-03, HostC, True, Win

2018-04-04, HostD, True, Win

2018-05-05, HostE, True, Win

2018-05-06, HostF, True, Win

2018-05-07, HostG, True, Win

2018-05-08, HostH, True, Win

2018-05-09, HostI, True, Win

2018-06-10, HostJ, True, Win

2018-06-11, HostK, True, Win

2018-06-12, HostL, True, Win

2018-06-13, HostM, True, Win

2018-06-14, HostN, True, Win

2018-05-10, HostO, True, Win

];

I want to present this data aggregated by date and counting (cumulating) the deployments like this:

For the "Deployments" column I'm using the following expression: RangeSum(Above(Count(distinct Host),0,RowNo(TOTAL)))

This works fine until I do selections on month - e.g. just displaying May and June 2018:

Due to the selection, the deployments of April are not counted. However I want the correct number of deployments being displayed independently of the selection of month.

Can anyone point me to the solution for this problem?