Calculation of Change in a Table

[laetizia_w]

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

I have such table:

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

[Urs_Boller · Accepted solution]

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/