Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.