Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2003
    Posts
    1

    Question Unanswered: Pivot table: how to make one in FileMaker 5.5?

    ***SUMMARY:
    How to make a pivot table (TotalAmount by Month by Category) from a list (Id- Month- Category- Amount) in FileMaker 5.5?


    ***IN DETAIL:

    Starting from this list of records:
    --ID----Month-Category-Amount
    ---1--Januari-------10-----28
    ---2--Januari--------6-----54
    ---3-Februari--------8-----31
    ---4--Januari-------10-----34

    1/ How can I compute the following pivot table: TotalAmounts by Category (rows) by Months (columns)?

    ---------------------MONTHS------------YEAR
    CATEGORY---Jan--Feb--Mar--[...]--Dec--TOTAL
    ---1-------104---87---90--[...]---98---1250
    ---2-------102---91---89--[...]---87---1343
    ---3-------112---98---98--[...]---90---1125
    ---4---------0----0----0--[...]----0------0
    ---5-------132--100--108--[...]--104---1258
    --TOTALS---450--376--385--[...]--379---4976

    2/ Is it possible to store these results in a dependent table for exportation- probably of the form:

    -YEAR--CATEGORY--TOTALS_FOR_JANUARY--TOTALS_FOR_FEBRUARY-[...]
    -2003---------1-----------------104-------------------87-[...]
    -2003---------2-----------------102-------------------91-[...]

    3/ How can I get the results for ALL rows (all possible values for Category)- including the non-used categories (e.g. category 4: total year amount = 0)?

    I kindly thank you for your time and help.
    Last edited by honger; 06-02-03 at 09:39.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •