in my raw data i have suppliers with the respective volume.
if a supplier makes sales in a month, a line with the corresponding month and year is written to my ro data. if this supplier does not make any sales in the following month, no one day is made.
My problem: I would like to write a line with a zero value in the month in which the supplier makes a one-day (see example in the appendix).
Date.xlsx (17.4 KB)
If you have furhter questions or sth. is not clear pls write me back.