Answers.Body: <p>Install Eileen's:
  <a href="https://civicrm.org/extensions/extended-reports" rel="nofollow">https://civicrm.org/extensions/extended-reports</a></p>
  
  <p>That will allow you to Filter for participants who have the 'Two Day Passes - 2' option. </p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-05T04:53:23.120Z
Answers.LastActivityDate: 2016-09-05T04:53:23.120Z
Answers.UserDisplayName: KarinG - Semper IT
Body: <p>I am using price sets with events. In all the reports it has 'Fee Level' and it looks like this</p>
  
  <p>Two Day Passes - 2,</p>
  
  <p>I can count the number of people who registered, but not the number of passes sold except via, filter on 'Fee Level' and 'sed and awk'.</p>
  
  <pre><code>awk -F',' '{print $6 }' Report_20160905-720.csv | sed 's/"//g' | awk -F ' - ' '{sum+=$2} END {print sum}'
  </code></pre>
  
  <p>The fees section of the event is setup with price sets and field type 'number' which is the count. If I purchase 2x $30 passes the form calculates the amount. The reports however, have Two Day Passes - 2 and I can't see how to add up the actual number of passes bought, just the number of registrations. </p>
  
  <p>Thanks</p>
  
Tags: <civievent><civireport>
Title: How to count event attendees with price sets and multiple bookings?
ThreadText: # How to count event attendees with price sets and multiple bookings?
  
  (Asked by: username_0 on 2016-09-04)
  
  I am using price sets with events. In all the reports it has 'Fee Level' and it looks like this
  Two Day Passes - 2,
  I can count the number of people who registered, but not the number of passes sold except via, filter on 'Fee Level' and 'sed and awk'.
  awk -F',' '{print $6 }' Report_20160905-720.csv | sed 's/"//g' | awk -F ' - ' '{sum+=$2} END {print sum}'
  
  The fees section of the event is setup with price sets and field type 'number' which is the count. If I purchase 2x $30 passes the form calculates the amount. The reports however, have Two Day Passes - 2 and I can't see how to add up the actual number of passes bought, just the number of registrations. 
  Thanks
  
  **Tags:** civievent, civireport
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-09-05. Score: 1
  
  Install Eileen's:
  <https://civicrm.org/extensions/extended-reports>
  
  That will allow you to Filter for participants who have the 'Two Day Passes - 2' option.
  
  
  ---
  
  