AnsweredAssumed Answered

Group Line Items by Month?

Question asked by TimothySlinks on Nov 29, 2011
Latest reply on Nov 30, 2011 by philmodjunk

Title

Group Line Items by Month?

Post

(Warning! I am using FMP10 without portal filtering!)

I have projects with line items. Each line item has a date and a dollar value. I want to see the top five projects with the most earnings by month, ideally through a portal.

For example, Project X has the following line items:
ItemA 10.22.2011 $500
ItemB 10.23.2011 $250
ItemC 11.22.2011 $425

If I choose "October" in my report layout, the portal displays:
Project X $750

If I choose "November", it displays:
Project X $425


I can set up the relationships and basic calculations, but this seems to require multiple summary fields. Will that work in a portal in a standard layout?

If I were to do this just through a report view, how can I limit the number of projects to the top five, and what calculations and summaries would I need to create?


This seems like a common report. I am just hazy on how summary fields work. Thanks for your help!

Outcomes