Hi,

I am trying to get around a problem I currently have with my system. At the moment, I am storing details of projects in a table and am using these tables later on to create pivot tables. However, in the table I have fields for multiple payments, so I would have cash payment 1 date, cash payment 1 amount, cash payment 2 date, cash payment 2 amount. The values are populated when I create a project entry using sharepoint.

The problem I am facing is that when I want to create a report to show how much cash was paid during 2013 for example, I find it difficult to do so due to having so many different cash payment dates and amount fields. I was hoping somebody could help with an idea or an alternative solution to storing this information in the table to allow me to create pivot tables more easily when I need to filter the results by dates. One probable solution is to create a different sharepoint page specifically for payments but I require the details from the main project entry to help filter out by region, city, etc.

Another note to mention is that many projects will have payments made over separate years, so payment 1 is made in 2012, payment 2 is 2013. I will attach a sample spreadsheet with the main field I will require.

Thank you in advance

Sample.xlsx