HI,
I'm trying to calculate in a pivot table (or in a linear graph), the percentage increase of a price list compared to each month compared to the first month (February over January, March over January, etc.). if I try to apply it, however, the columns of the months following the first are empty.
What am I doing wrong?
I would like to immediately thank anyone who can help me.
I'll paste an example of data and the formula I use.
Data:
Load * Inline [
Data, marca, listino
2020/01, A, 1000
2020/02, A, 2000
2020/03, A, 3000
2020/01, B, 1000
2020/02, B, 2000
2020/03, B, 3000
2020/01, C, 1000
2020/02, C, 2000
2020/03, C, 3000
2020/01, D, 1000
2020/02, D, 2000
2020/03, D, 3000
]
Formula Pivot:
(Avg(listino)
-
Avg(
{<Data={'2020/01'}>}
listino)
)
/
Avg(
{<Data={'2020/01'}>}
listino)
