January 20, 200620 yr A client enters in this report manually in excel. They'd like it generated through filemaker. Any thoughts on how to generate this report, based on the number of orders a client has? Thanks everyone!
January 20, 200620 yr This is possible. But it's going to need some work. You'll need self-relationships based on the following: Year Year & Month (20052 or 200502, either number or text) Year & months (12, fixed, Year & "1", Year & "2", ...Year & "12", matches above) Quarter (calculation) Year & Q The top "clients" part of the report would be a Subsummary part. The columns would be self-related Sum (amount field) based on the 12 self-relationships on YearMonthFixed to YearMonth. A column based on Last Year, a calculation to produce % of total. This would use GetSummary() fields or self-relationships with the client ID included: Year - 1 & ClientID (column 1) Year & ClientID (last column) Year & Month & ClientID (column 2) The section at the bottom with the quarters would be in a Trailing Grand Summary part, with the option [x] Do not break over page boundaries. There's also an Avg() function, in the Aggregates section, to use with self-relationships. Or a Summary field of Average, with GetSummary(). Not sure which I'd use. I tend to use self-relationships more, as they're also available in Browse mode. But for a report sorting (needed for GetSummaries) is a given, because of the Subsummary part(s).
January 20, 200620 yr Since you're certified isn't much harm done (Socrates corrupting the youth of Athens) in directing you in the direction of these 3 templates: http://www.kevinfrank.com/download/repeating-lookups.zip --sd
Create an account or sign in to comment