title: Google sheets - getting percentages of yes, no, maybe responses into a pivot table
body: <p>I have some data.  One of the columns (Column D) has data such as &quot;yes&quot;, &quot;no&quot;, 'Credit&quot;, &quot;n/a&quot;, &quot;half&quot;.</p>
  <p>At the top of that column, I have created a function which allows me to get percentage of &quot;yes&quot; responses, but not as a percentage of all responses, but just as a percentage of the responses that are &quot;Yes&quot;, &quot;No&quot; and &quot;Half&quot;
  Formula below</p>
  <p>=iferror((COUNTIF(C3:C, &quot;yes&quot;) / (COUNTIF(C3:C, &quot;no&quot;) + COUNTIF(C3:C, &quot;half&quot;) + COUNTIF(C3:C, &quot;yes&quot;))))</p>
  <p>Below that, starting at row 3, is the data.</p>
  <p>What I want to do is put data this into a pivot table.  One of my other Columns is date, and I want to be able to group the data by month (actually by week, but I have already worked that out).</p>
  <p>I am looking for my grand total value to be summarised using the formula above, which doesn't exist as one of the standard summary options.</p>
  <p>I am interested to hear your ideas on the best way to solve this.</p>
  <p>Thanks</p>
  <p>Edit:  here is a link to a sheet with the basics of what I am trying to do.  Thanks for your help with this.</p>
  <p><a href="https://docs.google.com/spreadsheets/d/1ew4pPv4qtJCZJCaUgg_I7VdL5F00t-PFhIlg2bs8sh0/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1ew4pPv4qtJCZJCaUgg_I7VdL5F00t-PFhIlg2bs8sh0/edit?usp=sharing</a></p>