Marimekko

Column widths come from the column totals, which is right for revenue, units or headcount. When the values are averages, ratios or prices they do not add up, and a column built from their sum is as wide as a coincidence. Bind a Width measure instead, such as market size or units sold; the footnote names it ("Column width: Units") and edit mode shows a hint when a ratio needs one.

The cost curve uses the same idea: Category is the plants, Values the unit cost and Width the capacity. The bars are sorted cheapest first, each as wide as its capacity, and the caption names the cheapest and the dearest plant and the capacity-weighted average.

Marimekko > Fold Small Players into Other is on by default: beyond the top five in each column, players under 5 % go to an Other cell for that column, named on hover and listed in the data table. A player that is large in one market and small in another stays visible where it matters. Top N Segments per Column sets your own number instead, and the Other label can be renamed.

Percentages are rounded within each column so they add up to 100 (largest remainder). Labels show value, % of column or % of total and player names, only where they fit; Labels Outside Thin Cells labels the thin cells of the last column to its right with leader lines. Column totals, a value axis, axis titles named after your fields and tooltips on every cell are free.

This is the market map review, and it is premium. Bind last year to Compare and every cell gets last year's boundary as a dashed line and its share shift in points, such as "Helios +4.0 pp" in Controls, each share over its own period's total. Compare > Segment CAGR Above Columns, with Years Between the Periods, puts each market's growth above its column, and Concentration (HHI, top 3) tracks how concentrated each market became.

Findings > What Changed writes up to five sentences with "how calculated": the fastest and slowest market, and per market who gained and who lost the most share. The share shift, relative share and CAGR come from engine functions golden-tested against pandas.

Relative Market Share (premium) divides each player's share by that of the largest rival in its column, BCG style: above 1 the player leads the market. Focus Player keeps one player in colour across every market and greys the rest, so Helios can be followed through the whole map.

With a focus player, Where Is the Prize outlines the share it does not hold yet in every market and ranks it by size, such as "#1 $3.1B open" in Pumps; Prize: Up to a Share of (%) caps the headroom at a realistic share instead of the whole market. A Target field draws a "vs target" band above the columns with met, close or missed, and on the cost curve, Cost Curve: Demand draws the demand line and names the marginal plant that serves the last unit.