How to find the values of a column in a query with Group By in rows that are not grouped?

I

Illarion Labahua2018-03-16 12:52:57

Google Sheets

Illarion Labahua, 2018-03-16 12:52:57

I have a table: DateOrderOrderNumber Shop Account ShopCanceledOrder
You need to select: The last date of the order and the corresponding order number for each pair {Shop\Account} and the corresponding value {ShopCanceledOrder}

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Alexander Ivanov, 2018-03-23
@oshliaer

It's probably about Google Sheets and the QUERY formula. You cannot make such a calculation.