4 Replies Latest reply on May 30, 2012 2:54 PM by madison.wang

    Newbie Average Calculation Help

      Hello,

       

      I am new to Tableau, so I apologize in advance if this question has already been asked or seems like a newbie question. I am trying to run a simple calculation in Tableau that doesn't seem to work no matter what I try. My data is confidential, so I can't post a workbook, so I guess I'll try to explain it as clearly as possible. I have six numbers stored in a row, lets call this Row A. I'm trying to take each of these six numbers and subtract it by the average of the row. In excel, this would look like this:

       

      ROW AAverage of ROW AGOAL
      13.5-2.5
      23.5-1.5
      33.5-0.5
      43.50.5
      53.51.5
      63.52.5

       

      How would I get from ROW A to GOAL?