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

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

    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:

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


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


    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