title: Calculated Column Count in SAP HANA
body: <p>I have a table with fields ID, Status and Changed Date like below:</p>
  
  <p><a href="https://i.stack.imgur.com/mkpnX.png" rel="nofollow noreferrer">Table</a></p>
  
  <p>How to create a Calculated Column wherein I should the count like:
  <code>Open       = 1
  In progress = 1
  Completed  = 1</code></p>
  
  <p>i.e., we should get the final status count of the ID.
  Instead I'm getting the count like:
  <code>Open       = 3
  Inprogress = 2
  Completed  = 1</code></p>