There is a weekly source feed getting where we have material number (part_number), atp & sales_org has atp value 0 or non-zero. When i join this with Sales Table based on material_number, i would like to show data on dashboard with rolling 12 months. But the challenge is that, in all fiscal weeks same part_number won't be available. so, wherever there is no value from data from source, there should be dummy data (part_number) and the atp value should be 0.
Attached screen is for reference where for few weeks the part_number and atp value doesn't exists but i would like to show same part_number into other weeks as well but atp should be 0. Please assist.
