# Absolute and percentage change aggregations For measures, you can set *Absolute change, Percentage change, Marketshare absolute change and Marketshare percentage change* aggregations. ### **Absolute change** The **Absolute Change** calculates the exact increase or decrease between two data points. This is essential for identifying trends, shifts, and changes in your data over time.

* **Dimension:** Select the dimension that the absolute change will be calculated over. * **Value 1 and Value 2:** Specify the two points between which the absolute change will be calculated. They define the scope of the comparison. * **Calculation formula:** *measure @Value 1 - measure @Value 2*. This represents the subtraction of one measure's value from another, showing the net change. * Click on **Create** to apply the absolute change aggregation to the selected measure. ### **Percentage change** The fields for the calculating percentage change is the same as that of the absolute change. However, the formula is different because it provides the change as a proportion of the initial value, which is expressed as a percentage.

The following formula calculates the change relative to the original value (Value 1). $$(Value 2−Value 1)/Value 1×100(Value 2−Value 1)/Value 1×100$$ Percentage change is a standard metric for performance analysis, and it also helps in identifying trends in data over time, regardless of dataset size. ### **Marketshare absolute change** **Marketshare Absolute Change** can be used for assessing the direct change in market share over specific periods and comparing market share between different market segments or product lines.

* **Dimension**: Select the relevant dimension. * Choose the specific data points for comparison. * **Value 1:** Select the initial point of comparison, such as the beginning of a quarter or year. * **Value 2:** Choose the endpoint for comparison, such as the end of a quarter or year. * **Calculation formula:** *measure @Value 1 - measure @Value 2*. This represents the subtraction of one measure's value from another, showing the net change. * After setting up the absolute change calculation, you are prompted to also add a **Market Share Target** filter, allowing for a targeted analysis of market share changes. * Click on **Create** to apply the marketshare absolute change aggregation to the selected measure. ### **Marketshare percentage change** The fields for the calculating marketshare percentage change is the same as that of the absolute change. However, the formula is different because it provides the change as a proportion of the initial value, which is expressed as a percentage.

The following formula calculates the change relative to the original value (Value 1). $$(Value 2−Value 1)/Value 1×100(Value 2−Value 1)/Value 1×100$$ Market share percentage change helps businesses understand their performance in the context of the market relative to competitors."