title: Tableau: exclude current row data from window average
body: <p>I have a student average marks information and i am working on performing some statistical things to find out the significance of the student vs overall score. Below is the screenshot of my data and I have also attached the data for reference.</p>
  
  <p>I am able to get the overall window average using the tableau's WINDOW_AVG function however i want to exclude the current row from being considered in the average.</p>
  
  <p><a href="https://i.stack.imgur.com/IpBxu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IpBxu.png" alt="Sample Data"></a></p>
  
  <p>For example, when i am calculating the overall average of student 7210, i must leave the 7210 student's Avg (83.320754717) and use the remaining student average for the overall average calculation. Similarly when calculating for 7211, i must leave the student avg (77.75806452) from being calculated in the overall.</p>
  
  <p>I have attached the data for reference in this <a href="https://drive.google.com/file/d/0B51kz2qSs8kHMWpJdmVsZzM0TTg/view?usp=sharing" rel="nofollow noreferrer">link</a>.</p>
  
  <p>Can anyone let me know how to proceed with this calculation?</p>