Body: <p>Our accountants are asking for a report that seems pretty reasonable but I am not finding a civicrm report that will deliver it.  Maybe there's one that does but not obvious, or an extension?</p>
  
  <p>All of our transactions are complex; very few have only one item.  So, the solution needs to be able to group by line item.  We need detail on each transaction, including date received and instrument type.  And each line item needs to be subtotalled.</p>
  
  <p>The closest I've gotten is "Extended Report - Contributions with Price Set data" or "Extended Report - Price Set Line Items".  Both of these will display the desired item detail but don't provide a dollar subtotal for each line item.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-10-11T20:11:11.493Z
Comments.Text: Drupal or not? Wondering if a bit of work to improve Views and line items would give you and others some good outcomes for this
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-10-11T21:33:15.030Z
Comments.Text: Looking for a native solution.  We're on Drupal but don't want to be tied to it.
Comments.UserDisplayName: Rob Brandt
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-10-12T00:15:02.657Z
Comments.Text: fair enough. let's see what others have to say
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2017-10-15T04:33:47.650Z
Comments.Text: I am not sure that there is a "Civi" way to sub-total each Line Item grouping (we use Sorting rather than Grouping). But you can export the report to Excel and very quickly Sum the groupings.
Comments.UserDisplayName: Iowa Boy
Tags: <reports><line-items>
Title: Line item detail report with subtotaled dollar amounts
ThreadText: # Line item detail report with subtotaled dollar amounts
  
  (Asked by: username_0 on 2017-10-11)
  
  Our accountants are asking for a report that seems pretty reasonable but I am not finding a civicrm report that will deliver it. Maybe there's one that does but not obvious, or an extension?
  
  All of our transactions are complex; very few have only one item. So, the solution needs to be able to group by line item. We need detail on each transaction, including date received and instrument type. And each line item needs to be subtotalled.
  
  The closest I've gotten is "Extended Report - Contributions with Price Set data" or "Extended Report - Price Set Line Items". Both of these will display the desired item detail but don't provide a dollar subtotal for each line item.
  
  **Tags:** reports, line-items
  
  > **Comments:**
  > **username_1**: Drupal or not? Wondering if a bit of work to improve Views and line items would give you and others some good outcomes for this  
  > **username_0**: Looking for a native solution.  We're on Drupal but don't want to be tied to it.  
  > **username_1**: fair enough. let's see what others have to say  
  > **username_2**: I am not sure that there is a "Civi" way to sub-total each Line Item grouping (we use Sorting rather than Grouping). But you can export the report to Excel and very quickly Sum the groupings.  
  
  ---
  
  ## 0 answers
  
  