Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sarangmmehta
Partner - Contributor II
Partner - Contributor II

Week wise Cumulative Sum reset to zero on month start

Hi All,

I have a set of data as attached.

I need cumulative sum at plant level and week level but not at month or year level.

At the start of every new month, the cumulative sum should start from 0.

I tried rangesum & above but could not achieve the desired result.

Please refer the input & output tab in the attached excel.

Request all to help me.

Thanks in advance.

Sarang M. Mehta

0 Replies