Aggr in not working with rangesum +count

[Rajkumar]

Hi Everyone,

I have to do cumulative sum from beginning to till date in the Pivot table. However it has to show only the last 8 days value in chart with cumulative sum. I used the below expression for that,It is working till rangesum. If I use the Aggr function it returns zero.Kindly advise what would be the issue?

sum({<DateNum={">=$(=date(max(DateNum)-8,'YYYYMMDD'))<=$(=date(max(num(DateNum)),'YYYYMMDD'))"} >}
aggr(rangesum(before(total Count(custID),0, NoOfColumns(total))),DateNum))

[Rajkumar]

@sunny_talwar Can you please assist on this ?