Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Avg(Aggr(Sum(listino), Marca, Data))
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?
Num(Aggr(Sum(listino), Marca, Data)/Aggr(Sum(Total listino), Marca, Data),'#,##0.000%')
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.