Skip to content
Adaptam Docs

WRITE_2D

Creates a two-dimensional output for data field values with vertical and horizontal headings.

WRITE_2D function overview

Function syntax

WRITE_2D(field_V1, ... | field_H1, ... | field_2D | filter1, ... | option1, ...)

Arguments:

  • field_V1, …: One or more vertical heading fields.
  • field_H1, …: One or more horizontal heading fields.
  • field_2D: The value field for each heading combination.
  • filter1, …: (optional) One or more data fields containing a filter value(s) that limit the values outputted. Filter values can reference cells, including cells with DROPDOWN selectors.
  • option1, …: (optional) Controls output with options explained in the guides: EVERY [change showing duplicates], LABELS [hide or show row/column heading labels], LIMIT_V [number of rows], LIMIT_H[number of columns], SORT [change order by field].

Examples

  • WRITE_2D(region | year | sales) - Sales by region (rows) and year (columns), where each individual sales value will be output.
  • WRITE_2D(product | quarter | revenue | country{“USA”}) - Revenue by product and quarter where country is USA, although if there are multiple rows of revenue for each combination of product and quarter this will output each one individually. If you want the summation, see WRITE_CALC_2D.