2 Replies Latest reply on Oct 31, 2018 3:15 AM by Hic Boux

    Correlation over several years - Display only one global value by item (country)

    Hic Boux

      Hello everyone,

       

      I have a table as following : Country, Year, Product 1 Price, Product 2 Price, Price 1 Evolution, Price 2 Evolution and Products Correlation.

       

      I created a field to calculate the pearson correlation rate between 2 product prices through the "CORR()" function but failed to display it properly in my sheet : I'm just able to show the correlation value per year, even if it remains constant over the years.

      I would like to have a view such as we can see on one side the name of the countries and next to it the value of the correlation.

       

      Do you know how to achieve that please ?

       

      Thanks in advance. My workbook file is attached to this post.

       

      Best regards,

      Hicboux