How to make the cube go outside the div?

Question

SQL

I get it like this
https://ibb.co/jvcwMR
But I need it like this
https://ibb.co/nJi31R
I'm talking about the footer, I need to make it go beyond the green zone
Thank you in advance

Answer 1

UPDATE dataset d
SET d.price = 
   (SELECT TOP 1 price FROM dataset d1 WHERE 
    d.good_id=d1.good_id AND d.owner_id=d1.owner_id AND d1.price IS NOT NULL AND 
    d1.year_id<=d.year_id AND d1.week_number<=d.week_number 
    ORDER BY d1.year_id DESC, d1.week_number DESC)
WHERE d.price IS NULL

True, this query is looking for the nearest date less than the missed one.

Answer 2

For SQL, there should always be a certainty: "as soon as possible" should become "nearest". And what to do with the goods if there is no such price.

Answer 3

margin with a negative value

Answer 4

If possible, then change it as it should be

Answer 5

show the code ... according to the screenshots, they guess at otvet.mail.ru/magic/