Skip to Content
0
Former Member
Feb 19, 2011 at 03:36 PM

Metric calc problem

22 Views

I want a metric, based on a value, to be able to be replicated across all dims..

i.e.

metric 1 = sum(X)

metric 2 = Sum(Case when @Select(dim) = 'CHARGE' THEN Sum(X) else 0 End)

thsi gives me;

col1 col2 col3

a 6 0

b 5 12

c 4 0

d 7 0

How can I get col3 to show all 12's???