1 2 Previous Next 17 Replies Latest reply on Dec 7, 2010 6:23 PM by BDH

    Sub Summary by column

    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,

        1 2 Previous Next