/profile-content.jspa?filterID=contentstatus[published]&targetUser=12709 Recent content in Tableau Community Forums en Fri, 30 Nov 2012 21:58:12 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2012-11-30T21:58:12Z en https://community.tableau.com/thread/121804 <!-- [DocumentBodyStart:8943c634-e7d3-4a02-80a1-b4eacab8f3e4] --><div class="jive-rendered-content"><p>I'm aware of LOOKUP function which allows to reference value of a cell in a row either above or below (i.e. lookup values vertically). Is there any function which allows to reference cells an adjacent column (i.e. lookup values horizontally)? </p></div><!-- [DocumentBodyEnd:8943c634-e7d3-4a02-80a1-b4eacab8f3e4] --> lookup vertically Fri, 30 Nov 2012 21:58:12 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/121804 2012-11-30T21:58:12Z 6 years 7 months ago 2 0 https://community.tableau.com/thread/121157 <!-- [DocumentBodyStart:dccd8ca2-d214-4197-8e8a-836fa25521e3] --><div class="jive-rendered-content"><p>Hi all,</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>&#160;&#160;&#160; Let's say I have a table that contains aggregated avg iPhone prices:</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><table border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><thead><tr><th style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><br/></th><th style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>Avg price <strong style="color: #ffffff; text-align: center;">iPhone 4</strong></strong></th><th style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;color: #ffffff;background-color: #6690bc;text-align: center;" valign="middle"><strong>Avg price iPhone 5</strong></th></tr></thead><tbody><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">UK</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">$333</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">$444</td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">US</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">$222</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">$311</td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Now I would like to compare iPhone 5 avg prices vs iPhone 4. In excel I would simply divide "iPhone 5_UK" by "iPhone 4_UK" and correspondingly "iPhone 5_US" by "iPhone 4_US" but how do I do it in tableau. Let's say creating four hardcoded parameters is not an option and I want to do it automatically.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Thanks,</p><p>Roman</p></div><!-- [DocumentBodyEnd:dccd8ca2-d214-4197-8e8a-836fa25521e3] --> Tue, 06 Nov 2012 02:20:55 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/121157 2012-11-06T02:20:55Z 6 years 8 months ago 1 0