4 Replies Latest reply on Jan 11, 2018 5:37 AM by Manuel Pérez Tórtola

    How to add Pearson Correlation coefficient at sub-total row

    Manuel Pérez Tórtola

      Tableau Desktop 10.3


      Hi all,


      I'm quite  new at Tableau and I'm stuck with this issue. I’ve been dealing with it for several days and I can’t find the solution.


      I’m working with Pearson Correlation Function (WINDOW_CORR)


      Just for the for this example based on Superstore data source I’m working with quantity and sales to find the Pearson correlation based on Order ID.


      What I want to do is:


      • To show Pearson CI at subtotal cell (In the case of sub-Category Accessories, 0,4247)
      • To show SUM(Sales)*Pearson CI. (Accessories $167,380 * 0.4247 = $71,086)



      I’ve been dealing with the solutions shown on these great posts.





      Unfortunately, I haven’t been able to solve the issue.


      Could anybody tell me what should I do? Or, even better, could anybody work  directly in the file I attach?


      Thank you very much in advance.



      Valencia - Spain


      Message was edited by: Manuel Pérez Tórtola