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

Thank you,

Satya Paleti

[Anonymous]

I don't think that this is possible

as I had this Kind of requirement, I found a workaround

maybe this would be an Option for you

-> create the straight table and a textobject with your target column

    create a Container and put both objects next to each other

    you may Format the objects to your requirements

disadvantage: by exporting to Excel you can only export the straight table

[Anonymous]

Hi Satya,

See attached.

Regards!

[marcus_sommer]

For this you need to add a further dimension which could be a calculated dimension, for example:

= 'All weeks'

which you put above your weeks and then you enabled partial sums (with the label Target for it) for this dimension and you used a query on the dimensionalities within the chart to assign the right expression, for example:

if(secondarydimensionality() = 0, TargetExpression, YourNormalExpression)

- Marcus

[SatyaPaleti]

Hi Manuel,

I didnt get any Attachment could you plz forward to satyapaleti@gmail.com

Thank you,

Satya