Pivot tables with the Aggregation Node
The Aggregation Node can help you produce the same kind of outputs as the Pivot Table in Microsoft Excel can, except that once it is set up, there is no need to do anything else if the upstream data changes. Everything is recalculated every time the flow runs. You don't need to jiggle anything every time the data changes.
This node is handy for counting things and summarising some statistics by categories. We help you get familiar with how to use it in this video:
