2 of 2 people found this helpful
1. Create a new calculated field called YOY with the forumula:
sum([Sales]) - LOOKUP(sum([Sales]),-12)
2. Add it to detail shelf of your viz
3. Update your tooltop and replace HELP!! with <AGG(YOY)>
4. RIght click the table calc YOY on the marks card and select edit table calculation. Set the dialog box to look like what I have in screenshot1.
The 2nd screenshot shows the desired outcome you seek. Hope this is what you need!
Thanks so much Jinesh! Wasn't familiar with the LOOKUP function.... it's really powerful!