Insert Extra Data and Dimension Into a Chart

[#1]

Hi There,

Just wondering if there is a shortcut to this problem.

I have a pivot chart that calculates a bunch of things based on the transaction data.

That customer wants me to insert a line into the chart with a hardcoded amount.

Is there a tricky way to do this without having to add this data line to the loadscript and "taint" the rest of the data in the model with this value?

e.g.

Account 1, Sum(Amount)

Account 2, Sum(Amount)

Insert Value here: Hardcoded Account Name, 10,000

Total: 25,000

The calcs in the attached picture are pretty complicated and dynamic. The customer just wants me to insert a hardcoded value as a line.

Any ideas before I do it the hard way?

Thanks

[sushil353]

do u want to insert a dimension?

your requirement is not clear

[#3]

Hi There,

Yes you are right. The requirement is hard to express.

Basically I want to insert a dimension within the existing dimensions.

So just in that chart concatenate a dimension to the existing ones.

Is it possible to do that as some sort of aggregate or something?

e.g. AccountGroups

contains

Cleaning

Stationery

I want to add another dimension e.g. HiddenCosts but HiddenCosts is not in the AccountGroups load from the database.

I then want the chart to present all the AccountGroups + HiddenCosts as a dimension.

I can then in the expression say if Dimension = HiddenCosts then value = 10,000 else Sum(Amount)

Make sense?

Thanks