This content has been marked as final. Show 3 replies
Hi Grit, I think this is what you're looking for:
- Create a calculated field like this IF [Order Date]< DATE(#1/1/2012#) THEN [Sales] END
- Put this on your right-Y axis instead of what you've got there now.
- Add the YOY quick table calc, and Tableau will create this calc: (ZN(SUM([Exclude 2012])) - LOOKUP(ZN(SUM([Exclude 2012])), -1)) / ABS(LOOKUP(ZN(SUM([Exclude 2012])), -1))
- Now go into the Edit Table Calculation\Customize and delete all the references to ZN. This gets rid of the 2012 line at zero %.
Hope this works for you.
Grit, you're welcome as always.