Hey community!
I've tried searching for an answer to this but can't seem to connect the dots (so I apologize if this is relatively simple).
Essentially what I have is a table that contains daily sales figures for several categories. The date is the rows while the categories are across the top as column headers. I need to add new columns for each category that adds a running total for the previous 35 days (so the 36th record would be the first entry, and it would populate all the way down). I've added a sample table below.
| date | cat A | cat B | cat C | running total - A | running total - B | running total - C |
| 1/1/2019 | 4 | 5 | 10 | | | |
| 1/2/2019 | 3 | 7 | 1 | | | |
| 1/3/2019 | 1 | 6 | 6 | | | |
| 1/4/2019 | 5 | 6 | 6 | | | |
| 1/5/2019 | 10 | 2 | 3 | | | |
| 1/6/2019 | 8 | 6 | 10 | | | |
| 1/7/2019 | 3 | 1 | 4 | | | |
| 1/8/2019 | 1 | 7 | 2 | | | |
| 1/9/2019 | 5 | 7 | 6 | | | |
| 1/10/2019 | 9 | 3 | 9 | | | |
| 1/11/2019 | 10 | 3 | 7 | | | |
| 1/12/2019 | 0 | 10 | 7 | | | |
| 1/13/2019 | 2 | 3 | 6 | | | |
| 1/14/2019 | 4 | 6 | 9 | | | |
| 1/15/2019 | 2 | 8 | 4 | | | |
| 1/16/2019 | 2 | 8 | 3 | | | |
| 1/17/2019 | 1 | 7 | 8 | | | |
| 1/18/2019 | 9 | 9 | 0 | | | |
| 1/19/2019 | 1 | 6 | 3 | | | |
| 1/20/2019 | 0 | 3 | 3 | | | |
| 1/21/2019 | 1 | 7 | 10 | | | |
| 1/22/2019 | 10 | 7 | 8 | | | |
| 1/23/2019 | 4 | 1 | 0 | | | |
| 1/24/2019 | 2 | 5 | 10 | | | |
| 1/25/2019 | 7 | 8 | 6 | | | |
| 1/26/2019 | 2 | 10 | 3 | | | |
| 1/27/2019 | 1 | 4 | 3 | | | |
| 1/28/2019 | 9 | 0 | 10 | | | |
| 1/29/2019 | 9 | 6 | 10 | | | |
| 1/30/2019 | 5 | 2 | 8 | | | |
| 1/31/2019 | 9 | 9 | 3 | | | |
| 2/1/2019 | 10 | 3 | 5 | | | |
| 2/2/2019 | 5 | 3 | 8 | | | |
| 2/3/2019 | 7 | 0 | 0 | | | |
| 2/4/2019 | 7 | 6 | 3 | 161 | 178 | 191 |
| 2/5/2019 | 3 | 7 | 4 | 164 | 179 | 184 |
| 2/6/2019 | 2 | 9 | 6 | 164 | 179 | 187 |
| 2/7/2019 | 10 | 4 | 1 | 165 | 182 | 187 |
| 2/8/2019 | 7 | 9 | 10 | 170 | 180 | 182 |
| 2/9/2019 | 8 | 7 | 3 | 167 | 187 | 189 |
| 2/10/2019 | 10 | 2 | 3 | 167 | 188 | 182 |
| 2/11/2019 | 6 | 8 | 10 | 174 | 189 | 181 |
| 2/12/2019 | 0 | 8 | 4 | 179 | 190 | 189 |
| 2/13/2019 | 10 | 9 | 8 | 174 | 191 | 187 |
| 2/14/2019 | 7 | 4 | 9 | 175 | 197 | 186 |
| 2/15/2019 | 2 | 1 | 3 | 172 | 198 | 188 |
| 2/16/2019 | 1 | 10 | 1 | 174 | 189 | 184 |
| 2/17/2019 | 4 | 2 | 4 | 173 | 196 | 179 |
| 2/18/2019 | 4 | 9 | 5 | 173 | 192 | 174 |
| 2/19/2019 | 6 | 1 | 6 | 175 | 193 | 175 |
| 2/20/2019 | 0 | 8 | 6 | 179 | 186 | 178 |
| 2/21/2019 | 1 | 2 | 8 | 178 | 187 | 176 |
| 2/22/2019 | 0 | 10 | 8 | 170 | 180 | 184 |
| 2/23/2019 | 5 | 5 | 4 | 169 | 184 | 189 |
| 2/24/2019 | 1 | 9 | 10 | 174 | 186 | 190 |
| 2/25/2019 | 10 | 7 | 6 | 174 | 188 | 190 |
| 2/26/2019 | 4 | 4 | 0 | 174 | 188 | 188 |
| 2/27/2019 | 3 | 10 | 1 | 174 | 191 | 188 |
| 2/28/2019 | 5 | 9 | 1 | 175 | 196 | 179 |
