title: SQL or HANA - How to create separate columns for each union statement in one report
body: <p>I have a HANA query that is summarizing sales data by year, by customer. </p>
  
  <pre><code>SELECT YEAR(T0."DocDate"), T0."CardName"  "Customer", SUM(T0."DocTotal")  "Sales Amt"
  FROM ORDR T0 GROUP BY YEAR(T0."DocDate"), T0."CardName"
  </code></pre>
  
  <p>It looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/b0Oos.png" alt="Current query results"></p>
  
  <p>What I am trying to figure out is, how to get the summaries by year to be displayed horizontally. </p>
  
  <p><img src="https://i.stack.imgur.com/yyYx7.png" alt="Something like this"></p>