Dear Team,
I have bellow Data set
Project | Week | date | sales |
ABC | week1 | 01/05/2020 | 10 |
ABC | week1 | 02/05/2020 | 20 |
ABC | week1 | 03/05/2020 | 30 |
ABC | week1 | 04/05/2020 | 40 |
ABC | week1 | 05/05/2020 | 50 |
ABC | week1 | 06/05/2020 | 60 |
ABC | week1 | 07/05/2020 | 70 |
ABC | week2 | 08/05/2020 | 17 |
ABC | week2 | 09/05/2020 | 18 |
ABC | week2 | 10/05/2020 | 19 |
ABC | week2 | 11/05/2020 | 20 |
ABC | week2 | 12/05/2020 | 21 |
ABC | week2 | 13/05/2020 | 22 |
ABC | week2 | 14/05/2020 | 23 |
| week2 | 15/05/2020 | 24 |
Basically I want to show in bar graph week1 data i,e in X axis it will show from 01/05/2020 to 07/05/2020 (week1 data)
but in measure I want to show cumulative sales amount
Example: for 01/05/2020 -- it is 10
02/05/2020 -- it is 10 + 20 (data of 1st May and 2nd May)
03/05/2020 -- it is 10 + 20 + 30 so on.....