Answers.Body: <p>You will want to use: <a href="https://civicrm.org/extensions/extended-reports" rel="nofollow noreferrer">https://civicrm.org/extensions/extended-reports</a> extension - it gives you access to many more templates - including price set - line item ones.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-14T20:29:14.550Z
Answers.LastActivityDate: 2017-11-14T20:29:14.550Z
Answers.UserDisplayName: KarinG - Semper IT
Answers.Body: <p>we are using a 3rd party PHP-based reporting tool which lets us get reports based on SQL queries on the civicrm database - the native Civi reports are template-based and more brittle IMO. You could run the event participants list, export the results to .csv and then sort the resulting rows by participant fee, or net amount after pulling the .csv into Excel.
   HTH</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-11-14T19:00:56.503Z
Answers.LastActivityDate: 2017-11-14T19:00:56.503Z
Answers.UserDisplayName: Lesley Evensen
Body: <p>I need a report for an event on Civi that lists how many guests bought tickets at the different levels we had our tickets for sale at. How can I do that? I can't figure out if it's possible with any of the 4 default reports Civi offers for events. </p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-11-14T23:42:16.867Z
Comments.Text: Hello Andrea. Welcome to CiviCRM Stack Exchange. Please edit your question to include anything you might have tried and the issue you encountered with those possible solutions or questions you have in documentation that wasn't clear. You may want to read up on the documentation for reports in the CiviCRM to get started and then refine your question. https://docs.civicrm.org/user/en/latest/events/reports/
Comments.UserDisplayName: Christia
Tags: <civievent><reports>
Title: How to pull an event report that lists how many people bought tickets at the different level of ticket prices
ThreadText: # How to pull an event report that lists how many people bought tickets at the different level of ticket prices
  
  (Asked by: username_0 on 2017-11-14)
  
  I need a report for an event on Civi that lists how many guests bought tickets at the different levels we had our tickets for sale at. How can I do that? I can't figure out if it's possible with any of the 4 default reports Civi offers for events.
  
  **Tags:** civievent, reports
  
  > **Comments:**
  > **username_1**: Hello username_0. Welcome to CiviCRM Stack Exchange. Please edit your question to include anything you might have tried and the issue you encountered with those possible solutions or questions you have in documentation that wasn't clear. You may want to read up on the documentation for reports in the CiviCRM to get started and then refine your question. https://docs.civicrm.org/user/en/latest/events/reports/  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2017-11-14. Score: 2
  
  You will want to use: <https://civicrm.org/extensions/extended-reports> extension - it gives you access to many more templates - including price set - line item ones.
  
  
  ---
  
  ### Answer by username_3 on 2017-11-14. Score: 0
  
  we are using a 3rd party PHP-based reporting tool which lets us get reports based on SQL queries on the civicrm database - the native Civi reports are template-based and more brittle IMO. You could run the event participants list, export the results to .csv and then sort the resulting rows by participant fee, or net amount after pulling the .csv into Excel.
  HTH
  
  
  ---
  
  