Perform YoY/MoM comparisons

更新时间:
复制 MD 格式

This topic uses a crosstab as an example to show how to perform year-over-year (YoY) and month-over-month (MoM) comparisons.

Procedure

  1. Log on to the Quick BI console and create a crosstab. For instructions, see Crosstabs.
    In this example, the crosstab includes the following data fields. 1
  2. In the Filter section, click the 过滤 icon to the right of the order date (month) field to set the filter range.
    In this example, the filter range is set as follows. 1
  3. To display YoY/MoM comparisons, configure the measure:
    1. In the Columns section, click the 1 icon to the right of the order amount field, and then select YoY/MoM Comparison > MoM.
    2. In the Measures list, find order amount and double-click it to add it to the Columns section.
    3. In the Columns section, click the 1 icon to the right of the second order amount field, and then select YoY/MoM Comparison > YoY.
    4. Click Update.
      The following figure shows the month-over-month and year-over-year comparisons of the order amount for each region from 2010-09 to 2012-12.