WITH

WITH adds extra rows or columns to the results without changing what the report measures. List one or more modifiers, separated by commas.

FROM sales
  SHOW total_revenue, units_sold
  GROUP BY vendor
  WITH TOTALS

Modifiers

Modifier	What it adds
`TOTALS`	An ungrouped total row across all results
`GROUP_TOTALS`	A subtotal row per first group, for a nested table
`PERCENT_CHANGE`	Percent-change columns versus the comparison period
`CUMULATIVE_VALUES`	Running-total columns accumulated over the sort order

PERCENT_CHANGE needs a comparison period, so pair it with COMPARE TO. CUMULATIVE_VALUES accumulates in the report’s sort order, so it works best alongside ORDER BY or a TIMESERIES.

FROM sales
  SHOW total_revenue
  DURING this_month
  COMPARE TO previous_period
  WITH PERCENT_CHANGE

Introduction

Syntax

Datasets

Examples

Modifiers

​Modifiers

Modifiers