Pivot: Calculation based on the pre-value and the month from column
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)".
