How To Add Hard coded field to Straight Table

[SatyaPaleti]

Hi Friends,

I really need a help for following Issue

I am Having a Straight Table. In that I need to show one particular field as a Target. Here is the Detail Requirement

I am getting Total. There should be one more column which is followed by Total it is Target.

Target is a Hard coded Column. It Have to show in Straight Table

Here is the excel how I need to show

Could you please help on this. Here you can find Sample data and Sample Qvw

Thank you,

Satya Paleti

[sunny_talwar]

Like this?

Expression:

=If(Dimensionality() = 0, 9.2, Avg([Total Sale]))

Enabled Total on the dimension limit tab

[SatyaPaleti]

Thank you sunny. but it's not working.if we add two or more expressions

[sunny_talwar]

What are the expressions you are using?

[tamilarasu]

Hi Satya,

Could you please post your script here. I am using personal edition.

[sunny_talwar]

This is not what you want?

[sunny_talwar]

Here it is Tamil:

LOAD Week,

     [Total Sale],

     [Total Org Id],

     Columns

FROM

[Sample_Data.xls]

(biff, embedded labels, table is Sheet1$);

[SatyaPaleti]

Exactly that is what I Require

[SatyaPaleti]

could you plzz send ur mail ID

[sunny_talwar]

So I added another expression and it seems to be working