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

    Calculation with column total (YTD)

    Jason Back



      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.