AATable

Synthetic demo
Info
Read-only worksheet table

Filters, groups and calculated fields apply locally to loaded rows. No workbook writeback.

Missing values show — and sort last. Group summaries require an explicit choice. Mean is unweighted.

CSV includes all matching records and visible columns, excluding group headers. Layout metadata only saves in this browser. Queries, groups, formulas and data do not.

Calculated fields: numeric [fields], + − * /, ABS, ROUND, MIN, MAX, COALESCE. Missing input, division by zero and non-finite results return missing.

Development prototype · not Tableau approved

Sample recordsSynthetic data
Row groups
Grouping help

Grouping organizes matching records into expandable folders; it does not remove records. Choose a field, click Add group, then click Expand on a group row to see its records. Add another field for a folder inside each group (up to three levels). Filters narrow the records; collapsing only hides them. Counts are records, not unique people. Summaries stay off until you choose one.

Worksheet summary table. Header buttons sort; missing values sort last.