Crosstabs that understand market research

Build crosstabs with subcolumns, percentages by row, column, cell and total, with means, index and top-box nets — and significance-test column differences right in the table. No export, no SPSS.

Try DataLion free
DataLion crosstab with subcolumns, percentages and top-box net rows

DataLion builds crosstabs with subcolumns and nested tables, percentages by row, column, cell and total, sums, means, median and index, plus top-box, top-2, top-3 and bottom net rows. Differences are significance-tested right in the table at 80–99% — as a heatmap, with in-cell bars and conditional formatting.

  • 🇩🇪 Made in Munich
  • GDPR-compliant
  • DPA included
  • Hosted in Germany

Trusted by research, insights & media teams

  • YouGov
  • SevenOne Media
  • Mediengruppe RTL Deutschland
  • Nielsen Sports
  • mobile.de
  • 50+ interactive chart types
  • 20+ statistical methods (R)
  • 2 weeks release cadence
  • ISO 27001 certified data centers (Germany)

Table books nobody wants to maintain

  • Banners and subcolumns are built in SPSS, then redone for reporting in Excel and PowerPoint — by hand, every wave.
  • Top-box nets, index and weighted bases live in side calculations instead of cleanly in the table.
  • Whether a difference between two columns is significant has to be checked separately and marked manually.

Subcolumns and nested tables

Put your question in the rows and as many subcolumns in the header as you need — by wave, target group, region or product. With nested tables you stack several dimensions and build complete banners.

The table stays consistent wave after wave: defined once, the same banner runs across every new data delivery — with nothing to rebuild.

  • As many subcolumns in the header as you need
  • Nested tables for multi-dimensional banners
  • Base columns and weighted bases per column
  • Consistent across every wave
DataLion table with nested subcolumns and base columns

Every metric you need — in one cell

Show absolute values or percentages by row, column, cell and total. Add sums, means, median and an index that relates each cell to the total sample — ideal for spotting over- and under-represented groups at a glance.

Every metric is also available weighted: valid base (validTotal), valid percent and weighted means recalculate automatically as soon as a weight variable is in play.

  • Percent by row, column, cell and total
  • Sums, means and median per column
  • Index against the total sample
  • Weighted bases, percent and means

Top-box, top-2 and bottom net rows

Combine scale points into net rows: top-box, top-2, top-3 and bottom are a few clicks away and sit as their own row right in the table — no helper columns, no side calculation.

This is also how you compute metrics like the NPS or a satisfaction top-2 reproducibly, always on the same documented definition.

  • Top-box, top-2, top-3 and bottom nets
  • Net rows right in the table, no helper columns
  • Reproducible, documented definitions
  • The basis for NPS and satisfaction metrics
DataLion table with top-box net rows and heatmap formatting

Significance right in the table

Differences between columns are tested directly in the crosstab — at four confidence levels (80%, 90%, 95%, 99%), as stars (*/**/***) or letters (a/A) for pairwise column comparisons.

Behind the scenes run the z-test, chi² and t-test on the R engine, with an optional Yates correction for chi². More on the significance testing page.

  • 4 confidence levels: 80/90/95/99%
  • Stars or letters for column comparisons
  • z-, chi² and t-test on the R engine
  • Optional Yates correction for chi²

Heatmaps, in-cell bars and difference columns

Numbers become a statement at a glance: color cells as a heatmap, show shares as in-cell bars and flag outliers with conditional formatting. Difference columns place the change between two waves or groups right alongside.

A DataLion table reads like a finished chart — and exports as natively editable PowerPoint, an Excel report book or a PDF.

  • Heatmaps and in-cell bars
  • Conditional formatting by threshold
  • Difference columns between waves or groups
  • Export as PowerPoint, Excel or PDF
DataLion crosstab with heatmap, in-cell bars and conditional formatting

See DataLion with your own data

Start a free trial or book a personal demo — from raw data to a finished dashboard.

Try it free Book a demo
We now work much more efficiently, giving us more time to take care of the derivations and insights from the data for the customers.
Jens Falkenau, Vice President of Market Research · Nielsen Sports
Read the case study →

More analysis features

Common questions about crosstabs

Can I build crosstabs with subcolumns and banners?
Yes. DataLion tables support as many header subcolumns as you need and nested tables, so you build complete banners by wave, target group, region or product — consistent wave after wave.
What percent and metric options are there?
Absolute values and percent by row, column, cell and total, plus sums, means, median, index and base columns — each also weighted as valid base, valid percent and weighted means.
Can DataLion compute top-box nets in the table?
Yes. Top-box, top-2, top-3 and bottom net rows are a few clicks away and sit as their own row in the table — the basis for metrics like NPS or a satisfaction top-2.
Is significance shown in the crosstab?
Yes. Column differences are tested right in the table at four confidence levels (80/90/95/99%) via z-, chi² or t-test and shown as stars or letters, with an optional Yates correction for chi².
How do I make a table readable without a chart?
With heatmaps, in-cell bars, conditional formatting and difference columns. The table reads like a chart and exports as natively editable PowerPoint, an Excel report book or a PDF.

Build your first crosstab

Try DataLion free: subcolumns, top-box nets, index and significance right in the tool — with no export. Or book a personal demo.

Try it free Book a demo