title: How to GROUP BY a column/s in data studio
body: <p>I have a sales table with the purchase history of multiple customers. Needless to say a single customer can appear multiple times in the table. I need to  group by the customers and do a count of the industries each customer works in and visualize it in a table in data studio. I need to do all of this in data studio itself.</p>
  
  <p>In big query the syntax would look something like this:</p>
  
  <pre><code>SELECT Industry, count(industry) AS industry_count 
  FROM (SELECT 
      CustomerID, 
      Industry 
      FROM `project1.pr.df_full` 
      WHERE  segment = 'Lost'
      GROUP BY CustomerID, Industry)
  GROUP BY Industry
  ORDER BY industry_count DESC
  </code></pre>
  
  <p>How can I achieve the same thing in data studio? The <code>WHERE</code> clause doesn't have to be there because I have a segment filter on the page I'm trying to do this on</p>