Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this?
Expression:
=If(Dimensionality() = 0, 9.2, Avg([Total Sale]))
Enabled Total on the dimension limit tab
Thank you sunny. but it's not working.if we add two or more expressions
What are the expressions you are using?
Hi Satya,
Could you please post your script here. I am using personal edition.
This is not what you want?
Here it is Tamil:
LOAD Week,
[Total Sale],
[Total Org Id],
Columns
FROM
[Sample_Data.xls]
(biff, embedded labels, table is Sheet1$);
Exactly that is what I Require
could you plzz send ur mail ID
So I added another expression and it seems to be working