/profile-content.jspa?filterID=contentstatus[published]&targetUser=45661 Recent content in Tableau Community Forums en Mon, 13 Oct 2014 16:52:47 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2014-10-13T16:52:47Z en https://community.tableau.com/thread/149994 <!-- [DocumentBodyStart:f72df805-818b-41a2-b292-4b20907b2a69] --><div class="jive-rendered-content"><p>hi, </p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>I have the following problem in applying a rule in a worksheet ... </p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>I have several branches where inventory decision is made in different months for each.</p><p>example: </p><p>Suc 1: March (83356 units); Julio (79017 units) </p><p>Suc 2: February (229503 units), June (210542 units) </p><p style="min-height: 8pt; padding: 0px;">&#160;</p><table border="1" class="jiveBorder" height="99" style="border: 1px solid rgb(0, 0, 0); width: 583px; height: 82px;"><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"><p><strong style="font-size: 10pt; line-height: 1.5em;">Suc / mes</strong></p></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>Enero</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>Febrero</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>Marzo</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>Abril</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>Mayo</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>Junio</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>Julio</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>Agosto</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"><p><strong>Septiembre</strong></p></th></tr></thead><tbody><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Suc 1</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">83356</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">79017</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td></tr><tr><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">Suc 2</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">229503</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;">210542</td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td><td style="border:1px solid black;border: 1px solid rgb(0, 0, 0);padding: 2px;"></td></tr></tbody></table><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>What I need is if I place myself to see the photo of inventory in April show me the inventory effect until that month, ie 1 Suc (83356 units) and Suc 2 (229503 units) </p><p>If I stand in June: Suc 1 (83356 units) and Suc 2 (210542 units) </p><p>If I stand in September: Suc 1 (79017 units) and Suc 2 (210542 units) </p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>I need to validate the last inventory data as the current value (according to the month you do the query), yet what you are doing is the sum</p></div><!-- [DocumentBodyEnd:f72df805-818b-41a2-b292-4b20907b2a69] --> Mon, 13 Oct 2014 16:52:47 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/149994 2014-10-13T16:52:47Z 4 years 8 months ago 6 0