Cumulative Sum (Across Dates)

[williamyuen96]

I have a problem where I can't use cumulative sum room occupied in the KPI 'Room Occupied'


When I filtered my dates to 1/1/2018, my room occupied is at 1761

And when I filtered my dates to 1/2/2018, my room occupied is at 3282

But when I filtered from 1/1/2018 to 1/2/2018, the figured does not cumulative sum it. Any idea how can I cumulative sum it ? Below is my QVF file