Hello Everyone!
Excuseme my english i'm Colombian jeje,
i need help for create a calculated table
i have a table as below:
| 1 | Comercial A | Customer X | Regional 1 | 01/01/2023 | 250.000 |
| 2 | Comercial A | Customer Y | Regional 2 | 01/02/2023 | 360.000 |
| 3 | Comercial A | Customer Z | Regional 1 | 01/03/2023 | 480.000 |
.
.
.
| 12 | Comercial A | Customer F | Regional 3 | 01/12/2023 | 650.000 |
| 13 | Comercial B | Customer G | Regional 2 | 01/01/2023 | 220.000 |
| 14 | Comercial B | Customer G | Regional 1 | 01/02/2023 | 150.000 |
.... etc. i have a one date per month per categories.
------------------------------------------------------------------------------------------------------------------------------------------------
i need a table as below:
| 1 | Comercial A | Customer X | Regional 1 | 01/01/2023 | 250.000/31 |
| 2 | Comercial A | Customer X | Regional 1 | 02/01/2023 | 250.000/31 |
| 3 | Comercial A | Customer X | Regional 1 | 03/01/2023 | 250.000/31 |
.
.
.
| 31 | Comercial A | Customer X | Regional 1 | 31/01/2023 | 250.000/31 |
| 32 | Comercial A | Customer Y | Regional 2 | 01/02/2023 | 360.000/28 |
| 33 | Comercial A | Customer Y | Regional 2 | 02/02/2023 | 360.000/28 |
| 34 | Comercial A | Customer Y | Regional 2 | 03/02/2023 | 360.000/28 |
.
.
.
| n | Comercial A | Customer Y | Regional 2 | 28/02/2023 | 360.000/28 |
| n | Comercial A | Customer Z | Regional 1 | 01/03/2023 | 480.000/31|
.
.
.
| n | Comercial A | Customer Z | Regional 1 | 31/03/2023 | 480.000/31|
| 13 | Comercial B | Customer G | Regional 2 | 01/01/2023 | 220.000 /31|
......etc
thank you very much in case you can help me 😊
