title: RANK() - Multiple columns in one query
body: <p>I've been struggling with a query where i have to create one rank dimension for several different columns into one query.</p>
  
  <p>I've tried to add multiple times the <code>RANK() OVER</code> clause, but it seems not to work with greater than 1 clause on the query.</p>
  
  <p>Example:</p>
  
  <pre><code>John - Sales program A: 10000 - Sales program B: 123 - Sales program C: 585
  Maria - Sales program A: 500 - Sales program B: 123213 - Sales program C: 432
  </code></pre>
  
  <p>I would need 3 columns with the rank of each Sales program.</p>