About Max Pivot Table
This page opens with the Maximum aggregate: Region as rows and no column field, so you get one column with the biggest Amount in each region. It is free, needs no sign-up and runs in your browser, so nothing you enter is uploaded.
The region maximums are East 9600, North 10800, South 8000, West 10800, and the largest of all is 10800. The total row of a maximum table is the largest value overall.
How to use Max Pivot Table
- Choose a file or paste your cells under Paste or upload data. The first row must hold the column names.
- Pick the Rows field: its values become the row labels.
- Pick the Columns field, or (none) for a single value column.
- Pick the aggregate and the Values field to summarise. Count does not need a values field.
- Read the table with its totals, then copy it or download it as CSV.
Features
- Sum, count, average, minimum and maximum.
- One row field and an optional column field, with a Total column and a Total row.
- CSV, TSV, XLSX, XLS and ODS input, read in a Web Worker.
- Labels sorted naturally, so 2 comes before 10 and (blank) is last.
- Totals computed from the source rows, not from the cell results.
- A count of rows skipped because the value was not a number.
- Copy as CSV or download.
Worked examples
Rows Region, maximum of Amount gives East 9600, North 10800, South 8000, West 10800
Overall maximum 10800.
Privacy: how it works
- Your table is read and summarised by code running in this browser tab. It is not uploaded or stored.
Tips
- Pick fields with few distinct values for rows and columns. A column field with hundreds of values makes a very wide table.
- Use Count with a text field to see how often each value appears.
- Dates summarise better once they are grouped, for example as a month or quarter column added to the source data.
- Blank labels are grouped under (blank) so those rows are never dropped.
Frequently asked questions
Is it really free?
Yes. There is no price, no trial and no credit card. Ulkaa Tool does the work with your own device, so there is no server bill to pass on to you.
Do I need an account?
No. There is no sign-up and no login. Open the page and use it. An Ulkaa account is not needed for anything on this tool.
Does it run in my browser?
Yes. Your table are processed by code running in your browser tab, on your own device.
Is my data uploaded?
No. Your table are never sent to Ulkaa or to anyone else. You can check this yourself by watching the Network tab in your browser developer tools while you use the tool.
Does it show which row has the maximum?
No, only the value. To see the row, sort your data in the SQL on CSV tool with ORDER BY and LIMIT.
More Pivot Table Maker pages
- Pivot Table MakerSummarise a table by rows and columns with sums, counts and averages, totals included.
- Pivot Table From CSVTurn a flat CSV into a summary with rows, columns and totals.
- Excel Pivot Table OnlineSummarise an Excel sheet without opening Excel.
- Count Pivot TableCount how many rows fall in each combination of two fields.
- Average Pivot TableShow the mean of a column for each group.
- Min Pivot TableShow the smallest value of a column for each group.