Static Column in KPI

[n1ef5ng1]

Hi guys, I am currently working on a KPI report

basically the table structure will be like

Revenue     Target     Jan     Feb     March .... Dec     YTD

I am able to generate data for month and revenue

however, is there any where that I can fit in the target column that is suppose to be key in manually without duplication due to month as my dimension

Basically my dimension consist of Months and Value List for Revenue

Expression is just the value list

Any help is appreciated

[#2]

use crosstable.

Crosstable(month,revenue)

load * from table1;

[#3]

Crosstable(month,Revenue)

load

Target,

Revenue,

jan, feb,mar, apr,....

from table;

[n1ef5ng1]

have to edit the script? possible to work on dimension or expression?

[n1ef5ng1]

my revenue column is an valuelist input

[#6]

you have to write it in edit script.

then use month as dimension and  Revenue  in expression of your chart or table

Crosstable(month,Revenue)

load

Target,

jan,

feb,

mar,

apr,....

from table;