
1. Re: Populating Cells with Measure Values
Shinichiro Murakami Sep 2, 2016 4:54 PM (in response to Luis Esturban)I don't know how many data do you have.
I mean if you have more than 10 data as Columns/Rows this is not feasible..
If it's 3~5, you can use this approach.
[Value a]
{sum(if [Title]="a. Num Trx Int" then [Value] end)}
[Value b]
{sum(if [Title]="b. Num Trx Nac" then [Value] end)}
[Value c]
{sum(if [Title]="c. Num Trx Total" then [Value] end)}
[a. Num Trx Int]
sum([Value])attr([Value a])
[b. Num Trx Nac]
sum([Value])attr([Value b])
[c. Num Trx Total]
sum([Value])attr([Value c])
Thanks,
Shin

Matrix_SM_9.2.twbx 12.5 KB


2. Re: Populating Cells with Measure Values
Luis Esturban Sep 5, 2016 11:14 AM (in response to Shinichiro Murakami)Hi Shinichiro,
Thanks for your answer. In my example only used 3 variables, but I need create a matrix with a Pearson correlation between 20 variables (more or less). All variables are measures and not necessarily needs a dimension.
The prefix LN in all variables means = natural logarithm = ln(x)
Thanks for your help
Sincerely,
Luis