Understanding TTest_sig with Pivot Table

shyamcharan — Mon, 26 Mar 2018 05:54:48 GMT

Hi Expert,

I am trying to create a pivot table that has dimensions as Sector, Zone and station as hierarchy.

I am using the TTest_sig() function to calculate significance value.

However, it does not work for me unless I create 3 different data sets one for Sector, one for Zone and one for Station.

For example:

Original Data Set:

Will the TTest_sig work currectly only when I have three different data sets like below?

Group by Sector data set

Group by Zonedata set

I get different results when calculating the TTest for the same data set but grouped differently. Please see the attache sample file.

Does this mean I have to create different set of data (as grouped above) to get correct results?

Regards,

Shyam

Re: Understanding TTest_sig with Pivot Table

shyamcharan — Thu, 29 Mar 2018 01:22:49 GMT

Hi There,

Can anyone please help me with my request ?

Thanks in advance.

Regards,

Shyam

shyamcharan — Tue, 17 Apr 2018 01:05:07 GMT

Hi Sunny,

Can you please help me with the above request?

I tried to use the SUM() in the function but it does not work.

TTest_Sig([OriginalDataSet.Year Month],[OriginalDataSet.Value])