Currency Format

The :currency format adds dollar signs and thousands separators to numeric values.

Interactive Example

Try It

TABLE
  ROWS occupation * gender
  COLS education * income.sum:currency
;

Dataset:samplesoccupation, education, gender, income

Try Variations

Query Breakdown

• income.sum:currency - Formats the sum of income as currency ($1,234.56)
• occupation * gender - Nests gender within occupation for row hierarchy
• education * ... - Nests the formatted measure under each education level

The :currency format is ideal for financial data, automatically adding the dollar sign and comma separators.

Related Examples

• Decimal - Control decimal precision
• Integer - Whole numbers with separators
• Multiple Formats - Different formats per measure
• Custom Format - Non-USD currencies and custom patterns