AnsweredAssumed Answered

Sub Summary by column

Question asked by BDH on Nov 27, 2010
Latest reply on Dec 7, 2010 by BDH

Title

Sub Summary by column

Post

Dear ,

I am new user of filemaker pro. I can not make a report that have items as a row sales amount by month as column. It is very simple in excel.

Data in the Table view:

Date           Item Name  Sales

1/1/2010   Item1           2,000

1/1/2010   Item2           5,000

1/1/2010   Item1           2,000

5/1/2010   Item1           2,000

7/1/2010   Item1           2,000

10/1/2010  Item1           2,000

12/1/2010   Item2          1,000

etc...

A report example is given below:

Item Name     January Sales     February Sales  March Sales

1. Item1          10,000              5,000                7,000

2. Item2            6,000              4,000                8,000

===================================

Total Sales      16,000              9,000                15,0000

We basically used excel previously but switched to filemaker recently. An example .fp7 file would be a great help. 

Thanks in advance.

Best Regards,

Outcomes