Hi
I wanted to add a calculated item in my pivot table with the following formula
% diff = (2022 - 2021)/ 2021
But excel give me the value = 0 if year 2022 value is greater than 2021 and -1 of the year 2022 value is less than year 2021, why is that? Why I do not see the correct number. Thank you very much
I wanted to add a calculated item in my pivot table with the following formula
% diff = (2022 - 2021)/ 2021
But excel give me the value = 0 if year 2022 value is greater than 2021 and -1 of the year 2022 value is less than year 2021, why is that? Why I do not see the correct number. Thank you very much
| Relationship.xlsx | ||||
|---|---|---|---|---|
| A | B | |||
| 3 | Row Labels | pro all | ||
| 4 | Blender | 53.91 | ||
| 5 | 2021 | 17.97 | ||
| 6 | 2022 | 35.94 | ||
| 7 | % Diff | 0 | ||
| 8 | Clothes iron | 43.75 | ||
| 9 | 2021 | 12.5 | ||
| 10 | 2022 | 31.25 | ||
| 11 | % Diff | 0 | ||
| 12 | Coffee maker | 80 | ||
Sheet5 | ||||
