Trun on the trend lines on sheet . So that you can see the correlation formula there.
Follow these steps on your view:
1.Right click on the view and choose trend lines and select show trend lines
2. after that once again right click the view and select trend lines and click on describe trend model.
If you want to calculate the correlation follow these steps:
1. Find the R-squared value in the describe trend model .
2. use a calculator and find the square root R sqaured value . That will be your correlation value.
This will let you know the correlation between sales and profit.