honger
06-02-03, 09:27
| ***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. |