Pivot tables
Total, average, count, or break down one column against another without writing a formula.
Pivot tables are part of PRO.
Opening the pivot panel
To open the pivot panel, click Pivot in the toolbar. You can also press Cmd+K (Ctrl+K on Windows and Linux) and type ‘pivot’.
Setting it up
You configure your pivot table by picking fields. BigXL fills in the result grid right away and updates it live as you change any of the three settings.
Row field This is the column whose values become the rows of the pivot table, like department names or product categories. Column field This is an optional choice to break the results down further, like months or regions. Measure column and aggregate This chooses the calculation for the cells. The available calculations are Number of rows, Total of, Average of, Median of, Smallest of, Largest of, Different values in, and Spread of (standard deviation).
Suggested pivots
BigXL looks at your column names and data types to suggest a pivot configuration. This suggestion is likely to be useful and helps if you are not sure how to start.
Color heatmap
The pivot cells are shaded by their values, with darker colors for higher numbers. This color heatmap makes it easy to spot the biggest and smallest values at a glance.
Why it exists
Pivot tables replace SUMIF, COUNTIF, and AVERAGEIF. These functions are not implemented as Formulas in BigXL. If you want to total a column grouped by another column, Pivot is the way to do it. No formula needed.
Exporting
You can export the pivot result as its own CSV, Excel, TSV or JSON file from the panel. This is useful when you need a summary table for a report without the full raw data.