2 Replies Latest reply on Oct 10, 2012 10:04 AM by Jonathan Drummey

YOY calculations through current month only

George Weatherwax Oct 10, 2012 6:36 AM

I feel like I'm missing an easy way to do a yearly comparison of YTD through end of October for 2011 vs. 2012 automatically. I can use the quick filters or parameters to allow users to choose, but want this to be automatically calculated.

Thanks for the help

1. Re: YOY calculations through current month only

Tracy Rodgers Oct 10, 2012 9:48 AM (in response to George Weatherwax)

Hi George,

A table calculation could potentially get you the desired outcome. Right click on your measure (on the view) and select Quick Table Calculation-->YTD Total.

http://onlinehelp.tableausoftware.com/current/pro/online/en-us/calculations_tablecalculations.html

-Tracy
Like Show 0 Likes(0)

Actions
2. Re: YOY calculations through current month only

Jonathan Drummey Oct 10, 2012 10:04 AM (in response to George Weatherwax)

Hi,

Are you asking for a comparison of YTD this year to the same period last year? If so, here's an older post on that same issue:

http://community.tableau.com/thread/119588
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

YOY calculations through current month only

1. Re: YOY calculations through current month only

2. Re: YOY calculations through current month only

Actions

More Like This