Correl function with aggregation

[#1]

Hello,

I want to calculate the correlation between two dataset. How can I use a set analysis in the correl expression. This is what I tried, but that doesn't work:

Correl(avg({$< Variable = {"P02.01"}>}TOTAL #score),avg({$< Variable = {"P03.01"}>}TOTAL #score))

Who can help?

[swuehl]

The Correl() function should operate on pairs of dimensional data values, not on a pair of scalar values.

I think you would need to apply advanced aggregation, something like

Correl(

Aggr( avg({$< Variable = {"P02.01"}>}#score), Dimension) ,Aggr(avg({$< Variable = {"P03.01"}>}#score), Dimension)

)