I am trying to enter a temporary array into a variable, from which I then want to output to the pivot table only those values that meet the condition "more than 30 percent" (the expression will be changed)
I tried to immediately display only the default values in the pivot table, but no formula works. So now I'm trying it through aggr.
How can I get not one number, but an array of data? Just as if I was writing an sql query with count(... group by...). I try the following formula, but it always gives me one number, not an array. And at the same time, this number is incorrect, if we talk about what I count inside the brackets. I need grouping by partner_name field.