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