How to Group Data Without Pivot Tables (Use GROUP_BY) | Datastripes
Group and summarize data in one formula, no pivot table
Pivot tables are powerful but fiddly for simple summaries. Datastripes gives you a GROUP_BY formula that groups and aggregates data in one line.
Why look for a pivot table alternative
Pivot tables need a field list, drag-and-drop areas and a refresh step, and they are easy to break when the source changes. For a quick "total by category" they can be more ceremony than the task deserves.The =GROUP_BY formula in Datastripes works like SQL GROUP BY inside a cell: choose the column to group by, choose what to aggregate, and the result is a normal table you can chart immediately.
From grouped table to chart
Because the output is a regular table, you can send it straight into a chart or dashboard. Change the source data and the grouped result updates with it.