Creating a KPI table

[vaisgaard]

Hi,

I need to do an Executive Summary, and one part of it is to show a table with KPI performance.

I have tried to used various P&L charts, but I cannot get it to work.

I want to create something like this:

In each field there would be an expression calculating the actual KPIs.

Any good ideas on how to do this?

I hope you can help.

BR

Michael

[sunny_talwar · Accepted solution]

You should be able to do this using ValueList() function. or you can use an Island Table to do this

[vaisgaard]

Hi Sunny,

Thank you very much. It points me in a direction.

I don't fully understand how it works, but I will investigate it further.

Have a nice day.

BR

Michael