Hi All,
I have a table that has mulitple rows for each date with an amount. I want to sum the amount by date, then have a running total of that sum:
Current table:
Date Amount
4/25 10
4/25 20
4/26 15
4/26 30
The output I want would be:
Date Amt Total
4/25 30 30
4/26 45 75
Thanks in advance!!
I have a table that has mulitple rows for each date with an amount. I want to sum the amount by date, then have a running total of that sum:
Current table:
Date Amount
4/25 10
4/25 20
4/26 15
4/26 30
The output I want would be:
Date Amt Total
4/25 30 30
4/26 45 75
Thanks in advance!!
Last edited: