# 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. 

<figure><img src="https://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/N4jq6XF12EIMzNtTilB9/image.png" alt="" width="563"><figcaption><p>Absolute change window</p></figcaption></figure>

* **Dimension:** Select the dimension that the absolute change will be calculated over.&#x20;
* **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.

<figure><img src="https://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/srbJOSAhEQWBSFJcACVo/image.png" alt="" width="563"><figcaption><p>Percentage change window</p></figcaption></figure>

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.

<figure><img src="https://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/2M12rFtdZLpvB8TTYflK/image.png" alt="" width="563"><figcaption><p>Marketshare absolute change window</p></figcaption></figure>

* **Dimension**: Select the relevant dimension.&#x20;
* 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.

<figure><img src="https://content.gitbook.com/content/z4Tm2IzKyAiWUWiskgq5/blobs/CAp9CQ5MjOmARRf8W39x/image.png" alt="" width="563"><figcaption><p>Marketshare percent change</p></figcaption></figure>

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."