Announcements
cancel
Showing results for
Did you mean:
Partner - Contributor III

## Calculation of increase in values

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:

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)

Labels (3)

• ### Set Analysis

4 Replies
Master
``Avg(Aggr(Sum(listino), Marca, Data))``

HirisH
“Aspire to Inspire before we Expire!”
Partner - Contributor III
Author

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?

Master
``Num(Aggr(Sum(listino), Marca, Data)/Aggr(Sum(Total listino), Marca, Data),'#,##0.000%')``
HirisH
“Aspire to Inspire before we Expire!”
Partner - Contributor III
Author

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.