Calculation of Change in a Table | Community
Skip to main content
New Participant
March 29, 2019
Solved

Calculation of Change in a Table

  • March 29, 2019
  • 1 reply
  • 1599 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Urs_Boller

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/

1 reply

Urs_Boller
Urs_BollerAccepted solution
New Participant
March 29, 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/