Yes you can. But you will need to use an Aggr function. Example:
=Aggr(distinct Count(OrderID),Product)
will create an array of numbers that represent "On how many orders does the the product X appear?"
Basically, the Aggr function creates an array using the first parameter of the Aggr function (which must be an aggregation) and the second (third, fourth, ...) parameter is equivalent to the GROUP BY in SQL.
/HIC
.png "Former Employee"){kind=icon}
