Im trying to do a group by to get a new column with total sum of charges by bill ID. I want the total sum to be constant all for every day associated with Bill ID. When I do a group by I am not getting the new column to sum the charges.
Bill ID | Date | Charge |
---|
502 | 4/10/2023 | $85 |
502 | 4/11/2023 | $76 |
502 | 4/12/2023 | $110 |
502 | 4/13/2023 | $78 |
502 | 4/14/2023 | $79 |
502 | 4/15/2023 | $115 |
502 | 4/16/2023 | $101 |
502 | 4/17/2023 | $94 |
502 | 4/18/2023 | $77 |
| | |
This is result i want. Could someone please assist?
Bill ID | Date | Charge | Total for Bill ID |
---|
502 | 4/10/2023 | $85 | $815 |
502 | 4/11/2023 | $76 | $815 |
502 | 4/12/2023 | $110 | $815 |
502 | 4/13/2023 | $78 | $815 |
502 | 4/14/2023 | $79 | $815 |
502 | 4/15/2023 | $115 | $815 |
502 | 4/16/2023 | $101 | $815 |
502 | 4/17/2023 | $94 | $815 |
502 | 4/18/2023 | $77 | $815 |
| | | |