This content has been marked as final. Show 2 replies
I have some questions about the correlation matrix.
(1) As is shown in the picture, when I filter the Indices,such as I choose A and B, and the Columns of correlation matrix and scatter plot become A and B, what I want to do is the Rows also become A and B.
(2) I want to do a action on this dashboard. If I click on the correlation matrix or scatter plot, such as I click on the correlation matrix(A and C), then it will filter the result of time series(only leave the line of A and C)) and scatter plot (a matrix containing A and C)
Attached is workbook that contains the Data set.
Your assistance will be highly appreciated.