I. Overview
1) Data can be compared through differences, for instance:
Compare the difference between assets in a month and those in the first month of the year.
Compare the difference between assets in a month and those in the first month of a period of time.
2) This article introduces how to calculate a difference through hierarchical coordinates.
II. Steps
1. Create a new dataset [ds1]
1) Create a new DB Query.
2) Input the following SQL function:
SELECT Year, Month, Assets FROM AssetDebt_equityGrowthWHERE YEAR='2010' OR YEAR='2011'
2. Design the report body
1) Type headers.
2) Drag data columns in [ds1] into the cell range B3:D3.
3) Preview.
3. Calculate the difference
1) Input the following formula in E3: D3 - D3[C3:1].
Formula segment | Meaning |
D3[C3:1] | Fetch the assets in the first recorded month of the year. |
D3 - D3[C3:1] | Compare the assets in the current month with the value fetched in the previous step. |
2) Input the following formula in F3: D3 - D3[B3:1,C3:1].
Formula segment | Meaning |
D3[B3:1,C3:1] | Fetch the assets in the first recorded month of the earlier year among all data. |
D3 - D3[B3:1,C3:1] | Compare the assets in the current month with the value fetched in the previous step. |