title: Pivot Table calculation
body: <p>I would like to calculate a new field which is Dose* quantity.</p>
  <p>I have a large dataset (3,000 rows) and the dose variable includes the unit of measurement in the cells. For example, doses are entered as &quot;30 mg&quot; or &quot;5 - 325 mg&quot;. How can I use pivot tables to calculate dose*quantity variables while ignoring the &quot;mg&quot; portion?</p>