Data360 Analyze

I want to separate the rows of data by every 7 rows.  Each row is a date, and that obviously changes every month. The reason I want to do this is to total every 7 days of the month and total the remaining days of the month after the first 4 sets of seven (besides February). I want the total line name to be the last date from the pull group. How can I separate each row by 7 and total each group?

Date               Entity 1   Entity 2   Entity 3   Entity 4
2/19/2023       $$              $$          $$          $$
2/20/2023       $$              $$          $$          $$
2/21/2023       $$              $$          $$          $$
2/22/2023       $$              $$          $$          $$
2/23/2023       $$              $$          $$          $$

I want to separate the rows of data by every 7 rows.  Each row is a date, and that obviously changes every month. The reason I want to do this is to total every 7 days of the month and total the remaining days of the month after the first 4 sets of seven (besides February). I want the total line name to be the last date from the pull group. How can I separate each row by 7 and total each group?

Date               Entity 1   Entity 2   Entity 3   Entity 4
2/19/2023       $$              $$          $$          $$
2/20/2023       $$              $$          $$          $$
2/21/2023       $$              $$          $$          $$
2/22/2023       $$              $$          $$          $$
2/23/2023       $$              $$          $$          $$

This might be helpful.  You could assign a week identifier to each record, by maybe finding the date of the end of the week, maybe the next Friday.  Or by identifying the Month by finding the first day of the month for each record.  I'm attaching a screenshot of this.

DateOfFriday and Month would then be available to aggregate by.

I want to separate the rows of data by every 7 rows.  Each row is a date, and that obviously changes every month. The reason I want to do this is to total every 7 days of the month and total the remaining days of the month after the first 4 sets of seven (besides February). I want the total line name to be the last date from the pull group. How can I separate each row by 7 and total each group?

Date               Entity 1   Entity 2   Entity 3   Entity 4
2/19/2023       $$              $$          $$          $$
2/20/2023       $$              $$          $$          $$
2/21/2023       $$              $$          $$          $$
2/22/2023       $$              $$          $$          $$
2/23/2023       $$              $$          $$          $$