title: Calculate median sales price with using 3 variables Tableau 10
body: <p>I would like calculate the median sales price and the median rental price for an apartment in NYC in each of the 5 boroughs, Brooklyn, Bronx Manhattan, Queens and Staten Island. In Tableau the sales and and rentals are groups of ListPrice -- Variables ListPrice is NUMBER(decimal) Type (includes Sales &amp; Rentals, Borough</p>
  
  <p>Any help is appreciated</p>
  
  <p>I tried using Tableau's table calculation feature but that did not work, I tried </p>
  
  <pre><code>WINDOW_MEDIAN(SUM([ListPrice])-1, -1)  
  
  ERROR: WINDOW_MEDIAN is being called with (float, integer), did mean 
  (float,integer,integer) 
  </code></pre>
  
  <p><strong>Data</strong></p>
  
  <pre><code>Type             Borough       ListPrice
  RentalType1      Manhattan       $5,000
  RentalType2      Bronx           $3,000
  RentalType2      Brooklyn        $3,000
  SalesType2       Manhattan       $900,000
  SalesType1       Brooklyn        $100,000
  SalesType1       Bronx           $500,000
  SalesType2       Queens          $800,000
  SalesType2       Staten Island   $400,000
  </code></pre>