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

    Newbie Average Calculation Help



      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


      How would I get from ROW A to GOAL?