title: Tableau calculated fields from 2 dimensions
body: <p>I have a situation in Tableau where I need to do a calculation, but am stuck as to how best to approach it.</p>
  
  <p>I have data in a table like this:</p>
  
  <p>Organisation ID (Measure), Country (Dimension), FY16 Status (Dimension has 3 different values (Low,Medium,High)), FY17 Status (Dimension has 3 different values (Low,Medium,High)).</p>
  
  <p>Sample of the Data:
  12345, France, Low, Medium
  12346, France, Medium, Medium
  12347, France, High, Medium
  12348, France, Low, High</p>
  
  <p>What I need to do is create a table that shows the following columns:</p>
  
  <ul>
  <li>Country (rows)</li>
  <li>Count of Organisations per FY16 Low</li>
  <li>Count of Organisations per FY17 Low</li>
  <li>(Count of Orgs per FY17 Low - Count of Orgs per FY16 Low)/Count of Orgs per FY16 Low.</li>
  <li>Count of Organisations per FY16 Medium</li>
  <li>Count of Organisations per FY17 Medium</li>
  <li>(Count of Orgs per FY17 Medium - Count of Orgs per FY16 Medium)/Count of Orgs per FY16 Medium.</li>
  <li>Count of Organisations per FY16 High</li>
  <li>Count of Organisations per FY17 High</li>
  <li>(Count of Orgs per FY17 High - Count of Orgs per FY16 High)/Count of Orgs per FY16 High.</li>
  </ul>
  
  <p>Any help would be greatly appreciated.</p>
  
  <p>Please find the link to the <a href="https://www.dropbox.com/s/wqtk3u6nvvxyjls/Country%20FY16%20vs%20FY17.twbx?dl=0" rel="nofollow noreferrer">Workbook</a> here with a description of what exactly I am trying to achieve also in the Dashboard.</p>