Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have the following requirement.
My Data table looks like below
ID | Week | Sales |
4294967379 | 2018/01 | 264,31 |
2018/06 | 90,27 |
I need to generate another Table wich looks similar to the one below
ID | Week | Sales |
4294967379 | 2018/01 | 264,31 |
2018/02 | 0 | |
2018/03 | 0 | |
2018/04 | 0 | |
2018/05 | 0 | |
2018/06 | 90,27 |
2018/42 | 0 |
So, on upto the current Calender Week.
I have a Calender Table with all the weeks. My Raw data gives me only the Weeks that have some Sales value present. I need to Insert 0 as sales where there are actually none.
Thanks
Sai.
Maybe like attached!
hope this helps
Perfect.
Vielen Dank!!
if your requirement is resolved now please close this thread by marking correct and helpful answers
Already marked your suggestion as correct