Forum Discussion
Deflated sales
Good afternoon community. I need your help to solve this problem. I want to be able to visualize in the same graph the sales of the selected year (from the YEAR friltro) where I am applying a measure...
I have these no-thousand billing values for a one-off customer.
Analysis Period: Last semester of the year 2024 vs. last semester of the year 2023 selecting in the filter year 2024.
Valore available
| Year/Month | jul. | ago. | sep. | oct. | nov. | Dec. | Total |
| 2024 | $41.019.362 | $74.340.732 | $31.223.287 | $60.361.283 | $54.574.277 | $729.189 | $262.248.129 |
| 2023 | $33.156.243 | $23.897.304 | $25.396.886 | $30.103.841 | $36.574.484 | $0 | $149.128.758 |
| Price increase (%) | 228.17% | 162.79% | 149,79% | 100.53% | 75.95% | 30.10% |
The problem I have is that now I want to deflate the values of the year 2024 to compare constant values vs the year 2023.
Desirable values
| Year/Month | jul. | ago. | sep. | oct. | nov. | Dec. | Total |
| 2024 deflated | $12.499.585 | $28.288.539 | $12.499.850 | $30.100.625 | $31.016.183 | $560.468 | $114.965.251 |
| 2023 | $33.156.243 | $23.897.304 | $25.396.886 | $30.103.841 | $36.574.484 | $0 | $149.128.758 |
| Price increase (%) | 228.17% | 162.79% | 149,79% | 100.53% | 75.95% | 30.10% | |
| Real Growth | -62% | 18% | -51% | 0% | -15% | 100% |