Absolute Cell value for Crosstab

[stancho]

Hi all,

I have the following crosstab:



ExecValueTotal = total of ExecValue for AB and BC.
I have Data Item1. Data Item1 expression is '[ExecValueTotal]'
but it shows the value of ExecValue (because it is filtered by AB or BC).
How can I set the Data Item1 expression to be the absolute value of the cell: ExecValueTotal?

Thanks,
Stancho

[RobsWalker68]

Hi,

Look at using the completeTuple function.  This will allow you to exactly set the value regardless of the context implied by the crosstab edges.

Regards

Rob

[stancho]

Thanks Rob!
I'll try it!

[stancho]

Rob I played with completeTuple function but:

if I set the expression of Data Item1 to:
completeTuple ([ExecValueTotal]) I get the total of ExecValueTotal column (577... + 581...) on every line.

I tried also something like completeTuple([ExecValueTotal], [MeassureDate]) .. (MeassureDate is the name of years).
also completeTuple([ExecValueTotal], [MeassureDate], currentMember([MyProject][Data][MeassureDate]) ) .. but always get errors... I saw these examples in the Tips for completeTuple function.

Any ideas?
Stancho

[RobsWalker68]

Hi Stancho,

Actually, just try the tuple function so define data item 1 as:

value(tuple(AB,Quantity)) + value(tuple(BC,Quantity))

Cheers


Rob