This content has been marked as final. Show 3 replies
I would like to create a rolling sum to display in a bar graph. Currently, I have a Date and Amount. I would like to sum the data for that day and the previous 2 days to create a "Running total" for a day. For example, on May 4 the Running Total would be 11. On May 3rd, the running total would be 13. On May 2nd, the Running total would be 10, because there is no date on 4/30. I wasn't sure how to create this and whether the best way to do this would be to create some sort of new field in the load script or via set analysis. The attachment is simply the table displayed below in excel format. Thanks for the help!