Correlation Analysis on two columns of a Pivot Chart

[#1]

I need help in figuring out a way to do a correlation analysis on two columns of a Pivot Chart.

I have following two dimensions in my dataset

1. Trade Date

2. Exchange ( this has values like NYSE, NASDAQ, CME, etc)

and the Measure is

1. Trade Value ( numeric)

Question -

I created a Pivot chart on the above mention dataset. It looks something like below.

Is there an easy way to perform a correlation analysis on two columns of a Pivot Chart???

I want to perform Correl(NYSE, NASDAQ). These two columns are field values of the Dimension - Exchange.

Trade Date	NYSE	NASDAQ
1/1/2014	3	2
1/2/2014	4	16
1/3/2014	5	15
1/4/2014	12	6
1/5/2014	9	14

[#2]

Yes.. Exaclty I want to perform Correl dynamically, based on various other selections.

Do you know of if it is possible to refer to entire column of Pivot Chart and use it in a function.

What I am thinking is - Lets say there was a way where I could refer to the second and Third column of Pivot Chart i.e and NYSE and NASDAQ and directly use it in Correl. Function

Correl ( PivotChart Column2, PivotChart Column3)

[sunny_talwar]

I don't think so... but you can look into Kaushik's suggestion of Generic load....

[kaushiknsolanki]

Vaibhav,

The way the correl() function is created inbuilt, is it requires 2 fields which are coming from database.

So i think only way is generic load in your case. Try with a small data and see how it goes and then you can decide about using it with huge data set.

Regards,

Kaushik Solanki

[jayanttibhe]

Like Attached  ?

Correl() returns the aggregated correlation coefficient for two data sets. The correlation function is a measure of the relationship between the data sets and is aggregated for (x,y) value pairs iterated over the chart dimensions.