Adding Data to missing Month Automatically

Karthick461

Hi,

 I have 3 columns in my Input. Product, Period and Sum(sales). 

Like this..

Product Period   Sum(Sales)

M1         2021001              50

M1         2021002              60

M2         2021001              10

M2         2021002              12

M2         2021003              12

M3         2021002              50

M3         2021003              30

My Requirement is M1 is not there for 2021003 . so my output needs to add M1 2021003 and sum(sales) as 0

same way M3 doesn't have record for 2021001 , so it has to add to output

Output should be like this

Product Period   Sum(Sales)

M1         2021001              50

M1         2021002              60

M1         2021003              0

M2         2021001              10

M2         2021002              12

M2         2021003              12

M3         2021002              50

M3         2021003              30

M3         2021001              0

Any help on this

atcodedog05

Hi @Karthick461 

Let me know if this works for you

Hope this helps : )

combo.yxmd