Pivot: Calculation based on the pre-value and the month from column

marcel_h — Sat, 16 Nov 2024 06:19:51 GMT

Hello,

I challenge to compute a value in a pivot table based on each month and its pre-value.

I have tried a few with rangesum () and before (), but I just can not get the result you want.

Condition:

I have a pivot table. In the columns I have the months 1-12. Then I have a selective metric for each month. The new calculated measure is based on the corresponding month and the pre-value.

1. Example value for month 1 is the original value.

2. Value for month 2 is "original value * 2 - sum(pre-values)."

3. Value for month 3 is "original value * 3 - sum(pre-values)".

4. ......

Please can anyone help me?

Thanks in advance.

topic Pivot: Calculation based on the pre-value and the month from column in App Development

Pivot: Calculation based on the pre-value and the month from column