title: Pivot and categories LIKE Usage
body: <p>My field has many distinct names such as:</p>
  
  <pre><code>Partner
  Partner UK
  Partner USA
  Associate - Senior
  Associate - Junior
  Junior Associate
  </code></pre>
  
  <p>And so on (more in the data than i've included here).</p>
  
  <p>I was originally pivoting my data as follows:</p>
  
  <pre><code>...pivot (count([NAME] for employee_rank in ([Partner], [Associate], [Analyst]) as pivottable
  </code></pre>
  
  <p>Until I realised I was missing all the sub-variants of each level.</p>
  
  <p>Is it possible to make the pivot categories more flexible such as:</p>
  
  <pre><code>...pivot (count([NAME] for employee_rank in ([LIKE '%Partner%'], [LIKE '%Associate%'], [LIKE '%Analyst%']) as pivottable
  </code></pre>