Use a total value in an expression

[#1]

Hello-How can I (or can I) use a column's total value in an expression -- but use that value in a different chart than the one it was originally calculated in? I want this value to stay static no matter what the user selects. Thanks! Tina

[#2]

You should be able to get the total of a column using the proper expression. You will need tohe expression used in the original chart and then probably the Aggr() function to aggreagate by your dimensions.

Aggr(OrigExpression, OrigDim1, OrigDim2, OrigDim3)

That would be the basis, but it really depends on your data set.

Are you looking for one value for the entire second chart or does the expression need to be evaluate separately for each dimension in the second chart?

I would think creating the expression in a variable would be the best way to use it in the second chart, but that may depend on the details.