Calculation of increase in values

[Roberto_Licciardello]

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)

[HirisH_V7]

Avg(Aggr(Sum(listino), Marca, Data))

[Roberto_Licciardello]

Hi HirisH,

thank you but it's not the correct solution. I need to calculate the percentage increase for each month compared to month one.

Any idea?

[HirisH_V7]

Num(Aggr(Sum(listino), Marca, Data)/Aggr(Sum(Total listino), Marca, Data),'#,##0.000%')

[Roberto_Licciardello]

Hi,

you're very kind, but unfortunately that's not what I'm looking for. It's a different problem, perhaps I explained it badly.