Pro-level analysis,
no expertise required
Link your tables, slice them any way you like, add your own metrics.
You ask the question, Summia builds the analysis.
Link your tables
Answers often sit across several tables. Sales, customers, products: Summia links them through the columns they share, so you can combine any columns without copying a single value.
Sales
| Order | Customer | Amount |
| O-1042 | Miller | 4,200 |
| O-1043 | Johnson | 1,850 |
Customers
| Customer | State |
| Miller | California |
| Johnson | Texas |
Revenue by state
| Q1 | Q2 | Margin % | |
| California | 48,200 | 52,900 | 31.4% |
| Texas | 36,750 | 41,300 | 28.9% |
Pivot tables from a single sentence
A pivot table saves hours, as long as you know how to build one. Just ask for it: it builds itself, rearranges with drag and drop, and updates along with your data.
RowsStateQuarter
Columnsdrop a field hereQuarter
ValuesSum of Revenue
| State | Quarter | Sum of Revenue |
| California | Q1 | 48,200 |
| Q2 | 52,900 | |
| Texas | Q1 | 36,750 |
| Q2 | 41,300 | |
| Grand total | 179,150 | |
| State | Q1 | Q2 |
| California | 48,200 | 52,900 |
| Texas | 36,750 | 41,300 |
| Grand total | 84,950 | 94,200 |
Add the margin as a %
ValuesSum of RevenueSum of CostMargin %
| Sum of Revenue | Sum of Cost | Margin % | |
| California | 101,100 | 69,360 | 31.4% |
| Texas | 78,050 | 55,490 | 28.9% |
| New York | 64,300 | 47,100 | 26.7% |
| Grand total | 243,450 | 171,950 | 29.4% |
Metrics that matter to you
A margin, a conversion rate, a budget variance: add your own calculation to the pivot table, just by describing it.
From the details to the big picture
Sum, average, median, minimum, maximum, count: pick the calculation, then collapse and expand the levels to go from the details to the total.
SumAverageMedianMinMaxCount
| Sum of Revenue | |
| California | 101,100 |
| Los Angeles | 44,300 |
| San Diego | 32,600 |
| San Jose | 24,200 |
| Texas | 78,050 |
| Houston | 39,800 |
| San Antonio | 26,450 |
| Dallas | 11,800 |
| Grand total | 179,150 |
What you can ask
“Revenue by state and by quarter, using the sales table and the customer list” “Median order value by acquisition channel, compared with last year” “The 10 products that contribute most to margin, with their share of the total” “Actual vs. budget variance by department, from largest to smallest” “Add the population of each state, with sources” “A dashboard of this month’s sales, with three charts”