Calculation of Change in a Table

laetizia_w

29-03-2019

I am having a question maybe someone could help me out.

I have such table:

forum.png

And I would like to see es coulums the value of last month, two month ago and the Change. Plus maybe our Goal value. Does anyone know how to get all this in one freeform because I have no idea how to do so with the Goal and the Change

I hope someone has a great Idea

Accepted Solutions (1)

Accepted Solutions (1)

ursboller

MVP

29-03-2019

you can insert date ranges "last month" and "2 month ago" as columns and you get the raw numbers. everything else is not easy to do, might be best done in excel with report builder.

however, if you are looking for a fany way and don't mind a lot of work, have a look in my blog post I wrote about the solution: https://perfectdashboard.rocks/kpi-summary-table/

Answers (0)