Answers.Body: <p>The <a href="https://civicrm.org/extensions/extended-reports" rel="nofollow noreferrer">Extended Reports extension</a> has a couple price set reports that should give you what you need.</p>
  <p>Another option would be to build your own table in SearchKit.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-08-15T17:32:44.813Z
Answers.LastActivityDate: 2023-08-15T17:32:44.813Z
Answers.UserDisplayName: Lars SG
Answers.Body: <p>Below is a SearchKit that I quickly threw together and exported.  Install it by going to <strong>Search menu » SearchKit</strong>, then clicking <strong>Import</strong> (it's just under the <strong>New Search</strong> button.  It shows each line item in its own row, though you could group together for one line per registration.</p>
  <p>Lars's suggestion of Extended Reports is easier to customize to your needs, but this is more flexible.  You also don't need to install an extension.</p>
  <p>Ideally in the future events are set up as event pages, which have better support for listing tickets purchased this way, but this or Extended Reports will get you similar functionality with a Contribution Page.</p>
  <pre><code>[
    [
      &quot;SavedSearch&quot;,
      &quot;save&quot;,
      {
        &quot;records&quot;: [
          {
            &quot;name&quot;: &quot;Line_Item_Example&quot;,
            &quot;label&quot;: &quot;Line Item Example&quot;,
            &quot;form_values&quot;: null,
            &quot;mapping_id&quot;: null,
            &quot;search_custom_id&quot;: null,
            &quot;api_entity&quot;: &quot;Contribution&quot;,
            &quot;api_params&quot;: {
              &quot;version&quot;: 4,
              &quot;select&quot;: [
                &quot;contact_id.display_name&quot;,
                &quot;receive_date&quot;,
                &quot;Contribution_LineItem_contribution_id_01.label&quot;,
                &quot;Contribution_LineItem_contribution_id_01.qty&quot;,
                &quot;Contribution_LineItem_contribution_id_01.unit_price&quot;,
                &quot;Contribution_LineItem_contribution_id_01.line_total&quot;
              ],
              &quot;orderBy&quot;: [],
              &quot;where&quot;: [],
              &quot;groupBy&quot;: [],
              &quot;join&quot;: [
                [
                  &quot;LineItem AS Contribution_LineItem_contribution_id_01&quot;,
                  &quot;INNER&quot;,
                  [
                    &quot;id&quot;,
                    &quot;=&quot;,
                    &quot;Contribution_LineItem_contribution_id_01.contribution_id&quot;
                  ]
                ]
              ],
              &quot;having&quot;: []
            },
            &quot;expires_date&quot;: null,
            &quot;description&quot;: null
          }
        ],
        &quot;match&quot;: [
          &quot;name&quot;
        ]
      }
    ]
  ]
  </code></pre>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-08-16T02:34:24.923Z
Answers.Text: As an aside @KHeath - if your support can't answer a simple question with a better answer than "Pivot Tables", you should consider replacing your support: https://civicrm.org/civicrm/experts
Answers.UserDisplayName: Jon G - Megaphone Tech
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-08-17T19:04:52.887Z
Answers.Text: Thank you both so much for these suggestions! Incredibly helpful and it will make our lives so much easier going forward. The gala takes a lot of staff time and attention and we're constantly checking the contributions to see if our outreach efforts have converted into tickets and revenue.
Answers.UserDisplayName: Kheath
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-08-16T02:32:13.160Z
Answers.LastActivityDate: 2023-08-16T02:37:38.393Z
Answers.LastEditDate: 2023-08-16T02:37:38.393Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>Turning in circles here and going crazy- I created a <a href="https://www.faccnyc.org/civicrm/contribute/transact?reset=1&amp;id=20" rel="nofollow noreferrer">contribution page</a> with a price set that includes numerical fields when guests want to purchase multiple individual tickets for our upcoming gala, in addition to radio button options.</p>
  <p>Nowhere am I able to create a contribution report that exports the total transaction amount and the value for this numerical field. For example, I want to quickly see that $1800 = 2, $900 tickets. So I will need the item price $900, quantity =2, and total = $1800.Obviously I can infer this but I want to export this quickly and frequently and be able to forward to my team without manual manipulation.</p>
  <p>I've tried a contribution details report, find contributions, and a Civi bookkeeping transactions report with filters by my target financial type. None of these options are giving me the data I need. I thought this was a relatively simple ask...but not with Civi...I contacted our support who was also stumped and advised to use pivot charts which I'm not an export in. I also tried IF formulas in excel and I have too many criteria. I just want my simple registration data.</p>
  <p>...can anyone point me in the right direction?...</p>
  
Tags: <contributions><reports>
Title: SOS- numerical field quantity in contribution export
ThreadText: # SOS- numerical field quantity in contribution export
  
  (Asked by: username_0 on 2023-08-15)
  
  Turning in circles here and going crazy- I created a [contribution page](https://www.faccnyc.org/civicrm/contribute/transact?reset=1&id=20) with a price set that includes numerical fields when guests want to purchase multiple individual tickets for our upcoming gala, in addition to radio button options.
  
  Nowhere am I able to create a contribution report that exports the total transaction amount and the value for this numerical field. For example, I want to quickly see that $1800 = 2, $900 tickets. So I will need the item price $900, quantity =2, and total = $1800.Obviously I can infer this but I want to export this quickly and frequently and be able to forward to my team without manual manipulation.
  
  I've tried a contribution details report, find contributions, and a Civi bookkeeping transactions report with filters by my target financial type. None of these options are giving me the data I need. I thought this was a relatively simple ask...but not with Civi...I contacted our support who was also stumped and advised to use pivot charts which I'm not an export in. I also tried IF formulas in excel and I have too many criteria. I just want my simple registration data.
  
  ...can anyone point me in the right direction?...
  
  **Tags:** contributions, reports
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2023-08-15. Score: 1
  
  The [Extended Reports extension](https://civicrm.org/extensions/extended-reports) has a couple price set reports that should give you what you need.
  
  Another option would be to build your own table in SearchKit.
  
  
  ---
  
  ### Answer by username_2 on 2023-08-16. Score: 0
  
  Below is a SearchKit that I quickly threw together and exported.  Install it by going to Search menu » SearchKit, then clicking Import (it's just under the New Search button.  It shows each line item in its own row, though you could group together for one line per registration.
  Lars's suggestion of Extended Reports is easier to customize to your needs, but this is more flexible.  You also don't need to install an extension.
  Ideally in the future events are set up as event pages, which have better support for listing tickets purchased this way, but this or Extended Reports will get you similar functionality with a Contribution Page.
  [
    [
      "SavedSearch",
      "save",
      {
        "records": [
          {
            "name": "Line_Item_Example",
            "label": "Line Item Example",
            "form_values": null,
            "mapping_id": null,
            "search_custom_id": null,
            "api_entity": "Contribution",
            "api_params": {
              "version": 4,
              "select": [
                "contact_id.display_name",
                "receive_date",
                "Contribution_LineItem_contribution_id_01.label",
                "Contribution_LineItem_contribution_id_01.qty",
                "Contribution_LineItem_contribution_id_01.unit_price",
                "Contribution_LineItem_contribution_id_01.line_total"
              ],
              "orderBy": [],
              "where": [],
              "groupBy": [],
              "join": [
                [
                  "LineItem AS Contribution_LineItem_contribution_id_01",
                  "INNER",
                  [
                    "id",
                    "=",
                    "Contribution_LineItem_contribution_id_01.contribution_id"
                  ]
                ]
              ],
              "having": []
            },
            "expires_date": null,
            "description": null
          }
        ],
        "match": [
          "name"
        ]
      }
    ]
  ]
  
  > **Comments:**
  > **username_2**: As an aside @KHeath - if your support can't answer a simple question with a better answer than "Pivot Tables", you should consider replacing your support: https://civicrm.org/civicrm/experts  
  > **username_0**: Thank you both so much for these suggestions! Incredibly helpful and it will make our lives so much easier going forward. The gala takes a lot of staff time and attention and we're constantly checking the contributions to see if our outreach efforts have converted into tickets and revenue.  
  
  ---
  
  