A data analysis tool that automatically inserts summary rows and calculates subtotals for grouped data in a list.
Essayer avec l'IAThe Subtotal feature organizes data by inserting subtotal rows at each change in a specified column. It automatically applies functions like SUM, AVERAGE, or COUNT to the grouped data and creates an outline for easy collapsing or expanding of details.
If you have a sales list sorted by region, you can use the Subtotal feature to automatically calculate the total revenue for each specific region.
Yes, the data must be sorted by the column you intend to group by, otherwise the tool will create a new subtotal row every time the value changes.