table with expressions as columns

[#1]

Hello everoybody

I want to build a table which consists of expressions (as columns) and fields from a Data Source (as rows). (Picture)

The First column is calculated via a variable (set_ID):

min({1<ID = {$(=set_ID)}>} [KPI x]

Columns C and D should look like:

max(KPI x)

min({1<ID = {$(=set_ID)}>} [KPI x] – max(KPI x)

… and so on for the following columns.

KPI x shall change, depending of the row.

How can I realize that? I’m not sure where I have to define the rows.

Thank you

[Anil_Babu_Samineni]

I didn't understand your question. Would you be able to share sample, Expected?

[#3]

Something like this: (hope you can see the added picture?)

column 1:     KPI 1 vas the value "50" for ID=2

column 2:     the avg of KPI 1 is 61.5

column 3:     and the difference between the value of the selected ID and the avg of KPI 1 is "-11.5".

But now I want to add additional rows, which display the values for KPI 2, KPI 3, KPI 4 and KPI 5.

So that for each KPI there is one row.

[sunny_talwar]

I would suggest using The Crosstable Load to convert individual KPIs into a field called KPI and then I feel that it would be easier to manipulate using KPI as a dimension