Hi, I currently have this table:
Date | Store | Value |
---|
1-Jun | A | 4 |
2-Jun | A | 2 |
3-Jun | A | 7 |
4-Jun | A | 3 |
5-Jun | A | 5 |
1-Jun | B | 9 |
2-Jun | B | 3 |
3-Jun | B | 4 |
4-Jun | B | 4 |
5-Jun | B | 8 |
1-Jun | C | 6 |
2-Jun | C | 3 |
3-Jun | C | 9 |
4-Jun | C | 5 |
5-Jun | C | 2 |
How can I have the 'Value' column to take the 1st day of the month value?:
Thanks.