/profile-content.jspa?filterID=contentstatus[published]&targetUser=7848 Recent content in Tableau Community Forums en Thu, 05 Jul 2012 06:43:03 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2012-07-05T06:43:03Z en https://community.tableau.com/thread/118240 <!-- [DocumentBodyStart:a9fc5986-a700-43ca-93c8-3757cd09fe42] --><div class="jive-rendered-content"><p>Hi Guys,</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>I am stuck with this issue in Tableau. I want to calculate year on year growth and then consolidate them by Industry. I am using the formula</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>(Current Year Sales -Previous Year Sales)/Previous Year Sales</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>I created a custom calculation and when I added it to Measure Values the percentage growth shows 1000% even though there was a decline in the figures. My question is how to create a proper Calculation and then add it to measures?</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Thanks</p><p>Anurag</p></div><!-- [DocumentBodyEnd:a9fc5986-a700-43ca-93c8-3757cd09fe42] --> yoy growth Thu, 05 Jul 2012 06:43:03 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/118240 2012-07-05T06:43:03Z 6 years 12 months ago 9 0