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.