Answers.Body: <p>Check out the Pivot Report extension at 
  <a href="https://civicrm.org/extensions/civicrm-pivot-reports" rel="nofollow noreferrer">https://civicrm.org/extensions/civicrm-pivot-reports</a> 
  and 
  the ReportPlus extension at
  <a href="https://civicrm.org/extensions/reportplus" rel="nofollow noreferrer">https://civicrm.org/extensions/reportplus</a> . 
  Both should give you a way to produce the report you want, I believe.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-28T18:42:47.657Z
Answers.Text: Thanks, Joe. For some reason, the Pivot Report won't load the Contribution report. The progress bar goes beyond 100% and never stops rising. The ReportPlus contribution reports don't have Line Item fields as column or filter options. The report I'm successfully using is http://example.com/civicrm/report/price/lineitem. Due to how we have our data set up, I need to display and filter on those Line Item fields.
Answers.UserDisplayName: Carl Sigmond
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2019-11-27T05:26:27.837Z
Answers.LastActivityDate: 2019-11-27T05:26:27.837Z
Answers.UserDisplayName: Joe McLaughlin
Body: <p>Is there a way to display a column total when viewing a report?</p>
  
  <p>Specifically, we are wanting to run reports on contribution line items and quickly see the contribution line item total. </p>
  
  <p>When you do Find Contributions, it displays the total, # completed, and average. Due to how we have our data set up, we need to use the line item report to view all of our donations; we can't use Find Contributions. I'm looking for a way for staff to quickly see donation totals from those line item reports.</p>
  
  <p>Interestingly, if you run a line item report (<a href="http://example.com/civicrm/report/price/lineitem" rel="nofollow noreferrer">http://example.com/civicrm/report/price/lineitem</a>) and you don't have any sort criteria, it will display a total at the bottom, but if you enable sorting, that total goes away.</p>
  
  <p>Any ideas?</p>
  
  <p>Many thanks,
  Carl </p>
  
Tags: <civireport>
Title: Displaying a column total in a report
ThreadText: # Displaying a column total in a report
  
  (Asked by: username_0 on 2019-11-27)
  
  Is there a way to display a column total when viewing a report?
  
  Specifically, we are wanting to run reports on contribution line items and quickly see the contribution line item total.
  
  When you do Find Contributions, it displays the total, # completed, and average. Due to how we have our data set up, we need to use the line item report to view all of our donations; we can't use Find Contributions. I'm looking for a way for staff to quickly see donation totals from those line item reports.
  
  Interestingly, if you run a line item report (<http://example.com/civicrm/report/price/lineitem>) and you don't have any sort criteria, it will display a total at the bottom, but if you enable sorting, that total goes away.
  
  Any ideas?
  
  Many thanks,
  Carl
  
  **Tags:** civireport
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2019-11-27. Score: 1
  
  Check out the Pivot Report extension at
  <https://civicrm.org/extensions/civicrm-pivot-reports>
  and
  the ReportPlus extension at
  <https://civicrm.org/extensions/reportplus> .
  Both should give you a way to produce the report you want, I believe.
  
  > **Comments:**
  > **username_0**: Thanks, Joe. For some reason, the Pivot Report won't load the Contribution report. The progress bar goes beyond 100% and never stops rising. The ReportPlus contribution reports don't have Line Item fields as column or filter options. The report I'm successfully using is http://example.com/civicrm/report/price/lineitem. Due to how we have our data set up, I need to display and filter on those Line Item fields.  
  
  ---
  
  