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))
