Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi friends,
I have this problem:
Date | Category | Value |
1 Apr 2023 | Refund | 10 |
1 Apr 2023 | Sales | 15 |
2 Apr 2023 | Requests | 5 |
2 Apr 2023 | Refund | 22 |
2 Apr 2023 | Sales | 3 |
3 Apr 2023 | Requests | 2 |
3 Apr 2023 | Refund | 1 |
3 Apr 2023 | Sales | 20 |
I need an additional column giving sum over the date. Example, column "Sum" should have the value,
Date | Category | Value | Sum |
1 Apr 2023 | Refund | 10 | 25 |
1 Apr 2023 | Sales | 15 | 25 |
2 Apr 2023 | Requests | 5 | 30 |
2 Apr 2023 | Refund | 22 | 30 |
2 Apr 2023 | Sales | 3 | 30 |
3 Apr 2023 | Requests | 2 | 23 |
3 Apr 2023 | Refund | 1 | 23 |
3 Apr 2023 | Sales | 20 | 23 |
Thanks.
Solved! Go to Solution.
Hi,
this should work:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi,
this should work:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |