Answers.Body: <p>The new search extension (ships with 5.30 but is still hidden &amp; you have to install via the api) gets close - you can see it's giving numbers for financial type &amp; I don't have a friendly theme enabled but the totals are there</p>
  <p><a href="https://i.sstatic.net/AJHFC.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/AJHFC.png" alt="search creator" /></a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-21T15:11:31.460Z
Answers.Text: The numbers for financial type thing should be fixed by 5.31.
Answers.UserDisplayName: Coleman
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-22T06:55:39.293Z
Answers.Text: Thank you Eileen and Coleman. The thing is I need one row per contribution, not totals, and with the breakdown by financial type shown as columns. I will provide an example screenshot.
Answers.UserDisplayName: Edward Peters
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-25T12:39:54.183Z
Answers.Text: I've updated the screenshot to reflect what will be in the 5.31 release (which will be in rc from first Wed in Oct)
Answers.UserDisplayName: eileen
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-18T20:27:03.913Z
Answers.LastActivityDate: 2020-09-25T12:39:13.057Z
Answers.LastEditDate: 2020-09-25T12:39:13.057Z
Answers.UserDisplayName: eileen
Answers.Body: <p>I am not sure you would get the exact requirement you looking for but you can use contribution pivot reports to group the records based on financial type via</p>
  <ol>
  <li><a href="https://civicrm.org/extensions/extended-reports" rel="nofollow noreferrer">Extended report</a></li>
  </ol>
  <p>or</p>
  <ol start="2">
  <li><a href="https://civicrm.org/extensions/reportplus" rel="nofollow noreferrer">Report plus</a></li>
  </ol>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-17T12:54:21.800Z
Answers.Text: Thanks a lot Pradeep. I tried a bit but could not see how to configure each financial type to have its own column. I will try again.
Answers.UserDisplayName: Edward Peters
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-17T12:56:24.423Z
Answers.Text: Column would be difficult. I think you are referring to financial type of line item associated with contribution
Answers.UserDisplayName: Pradeep Nayak
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-17T13:16:43.590Z
Answers.Text: You don't need it to be its own column if you use a pivot as Pradeep is saying, which can sum up the contributions by the financial type, which I'm guessing is why you want it in its own column. You can also export to excel and do a pivot table there.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-09-17T12:48:16.953Z
Answers.LastActivityDate: 2020-09-17T12:48:16.953Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>I need a report of contributions which has a row for each contribution, and then analysis by showing a column for each financial type, and the total amount of the contribution in the right financial type column. Is there any way of doing this without programming an extension?</p>
  <p>I include a screenshot of the kind of thing I need. The columns to right of VAT are financial types, so each payment is broken down into VAT (if applicable) and one or more financial types.</p>
  <p><a href="https://i.sstatic.net/SK8sS.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/SK8sS.png" alt="enter image description here" /></a></p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-09-18T18:56:02.367Z
Comments.Text: How many financial types are we talking about? You want hard-coded columns for each one?
Comments.UserDisplayName: Coleman
Tags: <civireport>
Title: How to make a report with each Financial Type as a column?
ThreadText: # How to make a report with each Financial Type as a column?
  
  (Asked by: username_0 on 2020-09-17)
  
  I need a report of contributions which has a row for each contribution, and then analysis by showing a column for each financial type, and the total amount of the contribution in the right financial type column. Is there any way of doing this without programming an extension?
  
  I include a screenshot of the kind of thing I need. The columns to right of VAT are financial types, so each payment is broken down into VAT (if applicable) and one or more financial types.
  
  [![enter image description here](https://i.sstatic.net/SK8sS.png)](https://i.sstatic.net/SK8sS.png)
  
  **Tags:** civireport
  
  > **Comments:**
  > **username_1**: How many financial types are we talking about? You want hard-coded columns for each one?  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_2 on 2020-09-18. Score: 2
  
  The new search extension (ships with 5.30 but is still hidden & you have to install via the api) gets close - you can see it's giving numbers for financial type & I don't have a friendly theme enabled but the totals are there
  
  [![search creator](https://i.sstatic.net/AJHFC.png)](https://i.sstatic.net/AJHFC.png)
  
  > **Comments:**
  > **username_1**: The numbers for financial type thing should be fixed by 5.31.  
  > **username_0**: Thank you username_2 and username_1. The thing is I need one row per contribution, not totals, and with the breakdown by financial type shown as columns. I will provide an example screenshot.  
  > **username_2**: I've updated the screenshot to reflect what will be in the 5.31 release (which will be in rc from first Wed in Oct)  
  
  ---
  
  ### Answer by username_3 on 2020-09-17. Score: 1
  
  I am not sure you would get the exact requirement you looking for but you can use contribution pivot reports to group the records based on financial type via
  
  1. [Extended report](https://civicrm.org/extensions/extended-reports)
  
  or
  
  2. [Report plus](https://civicrm.org/extensions/reportplus)
  
  > **Comments:**
  > **username_0**: Thanks a lot username_3. I tried a bit but could not see how to configure each financial type to have its own column. I will try again.  
  > **username_3**: Column would be difficult. I think you are referring to financial type of line item associated with contribution  
  > **username_4**: You don't need it to be its own column if you use a pivot as username_3 is saying, which can sum up the contributions by the financial type, which I'm guessing is why you want it in its own column. You can also export to excel and do a pivot table there.  
  
  ---
  
  