1 of 1 people found this helpful
By any chance, could you share your workbook or a mockup of your data as that way would be easier to understand. Also, the calculation you uploaded works with what is displayed in your worksheet, so by itself does not provide much information.
I've attached the workbook that I'm referencing.
I also setup sheet1 just as all the tutorials had said to do... but again, this only allows me to so show a correlation between a single dimension (actually the same one twice per the table it's being pulled from).
I'm beginning to think that in order to compare two different dimensions, I don't need to do a Cartesian Product type of join... I can simply use the Pearson Correlation Coefficient to compare a single table using two different dimensions.... nonetheless, I still have no idea how.
Pearson1.twbx 7.4 MB
I am not sure you really seeking "correlation" in this case o not.
I mean I cannot understand which two measure you want to get correlation.
Above simply shows the defect ratio by Area x Model.
You can filter by family or whatever you want.
Pearson1_SM_10.5.twbx 7.6 MB