I'm sure this is a simple formula, but for some reason I am stumped today. Currently I'm using a formula for % Chg that calculates the difference between 2 specific dates:
sum( [sales 2012] ) / sum( [sales 2011] ) -1 then change the Field Property/Number to %
I need it to be more dynamic. I'm working with several years of data, so I require it to function for multiple values
showing the difference between each year for each Dimension.
Figured this one out myself. I've posted the example on Tabwiki if anyone is interested. Thanks
Comparing Percent Changes Between 2 Different Years.twbxhttp://community.tableau.com/docs/DOC-5506
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...