/profile-content.jspa?filterID=contentstatus[published]&targetUser=3744 Recent content in Tableau Community Forums en Sat, 08 Dec 2012 23:00:43 GMT Jive Engage 8.0.5.0 (http://jivesoftware.com/products/) 2012-12-08T23:00:43Z en https://community.tableau.com/thread/121914 <!-- [DocumentBodyStart:f034d26f-a9b5-42b7-b5fc-a2a5db01e1d1] --><div class="jive-rendered-content"><p>I am hoping you can help me briefly with a blending/joining issue...</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>I attach an example Excel and a Workbook ...</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>For each Country&#160; I am trying to work out Revenue per Sales Department employee.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>The revenue is at a country level</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>The employees are at a Department and Country level.</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>The model answer is on the answer sheet... how do I get Tableau to do this? </p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>When I join I get the&#160; revenue duplicated</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Give me a shout if I can clarify...</p><p style="min-height: 8pt; padding: 0px;">&#160;</p><p>Thanks</p><p>Duncan</p></div><!-- [DocumentBodyEnd:f034d26f-a9b5-42b7-b5fc-a2a5db01e1d1] --> Sat, 08 Dec 2012 23:00:43 GMT tableaucommunity@tableau.com https://community.tableau.com/thread/121914 2012-12-08T23:00:43Z 6 years 7 months ago 2 0