Calculating percentage change between months

johnnyjohn — Sat, 16 Nov 2024 02:54:47 GMT

I have the following data (minus the column in red. That column is the calculation I am trying to get)

Month	Salesperson	Sum data	% change
01/07/2019	John	10	-
01/07/2019	Mike	5	-
01/08/2019	John	100	900% (from 10 to 100)
01/08/2019	Mike	20	300% (from 5 to 20)

I would like calculate the percentage increase of a salesperson from one month to another, so I can have, for example, a line chart with months on the X axis and each line representing the percentage change of a particular salesman for that month vs the previous month.

How can this be done?

Thanks

Re: Calculating percentage change between months

ashishkalia — Mon, 23 Mar 2020 09:32:32 GMT

Hi @johnnyjohn ,

You need to handle this in the backend.

in your monthly number you need to add the last month numbers in the same table and in the same line.

Attached the QVW for your reference.

topic Re: Calculating percentage change between months in App Development

Calculating percentage change between months

Re: Calculating percentage change between months