Summarising Data 
Author Message
 Summarising Data
I am new to Filemaker.

I need to summarise a file that has over 20,000 records of:

item,week-date,units-sold

Can I get a single layout that will show a summary:

item,year,month,totalunitssold

Thanks.....



Tue, 19 Aug 2003 00:48:16 GMT
 Summarising Data

If you want to summarize by year and month, you need fields that have that
information.  I am assuming your field "week-date" is a date field and
"units-sold" is a number field.  I would suggest that you change those
field names to avoid confusion to WeekDate and UnitsSold, respectively.
Then, you would want to add 4 new fields:

TotalSales (summary) = Total of UnitsSold
CalcYear (calculation, number) = Year (WeekDate)
CalcMonth (calculation, number) = Month (WeekDate)
CalcMonthName (calculation, text) = MonthName (WeekDate)

On your layout you should have the following parts:

Header
Sub-Summary by CalcYear (leading)
Sub-Summary by CalcMonth (trailing)
Sub-Summary by CalcYear (trailing)
Footer

In the first Sub-Summary section, put your field titles.  In the second
section put CalcMonthName, CalcYear and TotalSales.  In the third section
put CalcYear and TotalSales.

Sort your records first by CalcYear and then by CalcMonth.  Go to Preview
mode.
--
Glenn Schwandt



Quote:
> I am new to Filemaker.

> I need to summarise a file that has over 20,000 records of:

> item,week-date,units-sold

> Can I get a single layout that will show a summary:

> item,year,month,totalunitssold

> Thanks.....



Tue, 19 Aug 2003 01:31:50 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Summarising Data - Part 2

2. Summarising Data

3. summarising in impromptu

4. AUTO refresh OLAP CUBE data after DATA WAREHOUSE DATA

5. Data Transfer from Long data type to SQL Server Text data type column

6. ANN: Data Dynamics releases ActiveCube 3.0 - Data Analysis ActiveX Control for MS Data Analysis Services

7. How to AUTO refresh OLAP CUBE data after DATA WAREHOUSE data is changed

8. Binary Data in SQL 2000/Conver to Bitmap Data For Data Grid View

9. Help - Simply Getting Data from Extrenal Data Files (not from Access Data Base)

10. MD-Annapolis Junction-240349--Data Warehousing-ORACLE-SQL-PL/SQL-Data Modeling-Data Warehouse Analysts

11. Data generation: Test Data: Dummy Data

12. Data Wharehouse - Data Mining - Data Stage - ......


 
Powered by phpBB® Forum Software