Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I didn't understand your question. Would you be able to share sample, Expected?
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.
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