0 Replies Latest reply on Dec 10, 2013 8:39 AM by Jason Back

    Calculation with column total (YTD)

    Jason Back

      Hello,

       

      I am trying to create a calculated field involving one calculated field and total column of another measure,

       

      In the example attached. I want to create a field that shows sales index variance from 2013 YTD (grand total in the sheet) to 2013 target.

       

      I tried to create one, and it only works when quarter and month columns are removed.

       

      Think I need to use functions such as lookup, first, last, index but not familiar how to use those in tableau.  Or, maybe there is another way to just a create a spate measure for 2013 YTD number and do calculation using two measures.

       

      If anyone has ideas, I would appreciate it very much.

       

      Jason