Showing Correlation Coefficient in Chart same column

[#1]

In this thread Showing Correlation Coefficient in Chart explain how calculating Correlation Coefficient in QLikview:

correl ([{set_expression}] [ total [<fld {,fld}>] ] x-expression, y-expression )

example:

X	Y
18	13
17	15
15	14
16	13
14	9

Correl(,) = 0.624037721

But my data is this:

Metric	Measure
X	18
X	17
X	15
X	16
X	14
Y	13
Y	15
Y	14
Y	13
Y	9

How can calculate Correlation, if it show error: =Correl({$<Metric={'X'}>}Measure,{$<Metric={'Y'}>}Measure)

Thanks for your help

[Anonymous]

I am also having this issue, can you use $ expansion to calculate correlations between specific measures? You should be able to.