This topic uses a crosstab as an example to show how to perform year-over-year (YoY) and month-over-month (MoM) comparisons.
Procedure
- 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.
- 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.
- To display YoY/MoM comparisons, configure the measure:
- In the Columns section, click the
icon to the right of the order amount field, and then select . - In the Measures list, find order amount and double-click it to add it to the Columns section.
- In the Columns section, click the
icon to the right of the second order amount field, and then select YoY/MoM Comparison > YoY.
- 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.
- In the Columns section, click the
该文章对您有帮助吗?