How can I create an expression that range sums on every 7 rows. For example, I am trying to get the table to sum the total of each week and then reset. For column CY WTD Currently, the expression I am using sums the total of all the weeks.
if([Fiscal - Flag Current PTD]='Y',
RangeSum(Above(
TOTAL
Column(1),0, RowNo(TOTAL)))))
I just need this expression to only rangesum 7 rows up.
![3-14-2019 1-54-45 PM.jpg 3-14-2019 1-54-45 PM.jpg](https://community.qlik.com/t5/image/serverpage/image-id/8058i3D7FE1CD1E55D1EA/image-size/large?v=v2&px=999)