title: obiee count distinct by as part of total count distinct
body: <p>I need create following "numeric distribution" report in OBIEE :</p>
  
  <pre><code>item name, 
  count(distinct item_id by item_name), 
  count(distinct item_id by item_name)/count(distinct item_id)
  </code></pre>
  
  <p>(third column should be percent of count distinct by item name / count distinct by total)
  How to get total count distinct ? I'm stuck and i will be appreciate any help.</p>
  
  <p>The result should be:</p>
  
  <pre><code> Item 1 , 10,  50%
   Item 2 , 20, 100%
  </code></pre>
  
  <p>where total number of customers is 20, and 10 od them buy Item_1, and 20 of them buy Item_2</p>