Calculating percentage change between months

[johnnyjohn]

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

[ashishkalia]

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.