Hello
I have a query that shows the correct details.
it should show 12-month data before the exact END DATE from exiting data .
for a specific case,I have just 2 2 month records to show.
How can I add a condition if the other months are not on the list put their value 1 or 100%.
this query :
change to this:
I have a query that shows the correct details.
it should show 12-month data before the exact END DATE from exiting data .
for a specific case,I have just 2 2 month records to show.
How can I add a condition if the other months are not on the list put their value 1 or 100%.
this query :
change to this: