Multiple queries by date in the same row in google sheets

Question

I need to sum the daily sales of each product ASIN. Sounds easy but I can`t do it.

On the left, you can see the data. At the right, the empty table that I need to create.

question from:https://stackoverflow.com/questions/66064919/multiple-queries-by-date-in-the-same-row-in-google-sheets

Answer 1

use:

=QUERY(K2:M; "select K,sum(M) where M is not null group by K pivot L")