Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Report of aggregate calcs

mrpez1
in Layouts

Featured Replies

I'm having some trouble putting together a report of summaries. I have an orders database with many orders in it and some aggregate calculations (i.e. Total quantity sold by product, total revenue by product, gross margin by product, etc...)

I'm trying to make a report that looks like this:

Broker (Sales Type)

Product 1 1555 $30,000

Product 2 (Quantitity sold) (Revenue)

Product 3 (Quantitity sold) (Revenue)

Product 4 (Quantitity sold) (Revenue)

Direct

Product 1 (Quantitity sold) (Revenue)

Product 2 (Quantitity sold) (Revenue)

Product 3 (Quantitity sold) (Revenue)

Product 4 (Quantitity sold) (Revenue)

Out Of State

Product 1 (Quantitity sold) (Revenue)

Product 2 (Quantitity sold) (Revenue)

Product 3 (Quantitity sold) (Revenue)

Product 4 (Quantitity sold) (Revenue)

As you can see, I want to summarize report on aggregate calculation data rather than data for each individual record. So far, I've gottent this to work but it will put an entry for each record. Is there anyway to combine all the broker sales of product 1 into 1 entry rather than have:

Broker

Product 1 1555 $30,000

Product 1 1555 $30,000

Product 1 1555 $30,000

Product 1 1555 $30,000

Product 2 (Quantitity sold) (Revenue)

Product 3 (Quantitity sold) (Revenue)

Product 4 (Quantitity sold) (Revenue)

Direct

Product 1 (Quantitity sold) (Revenue)

Product 2 (Quantitity sold) (Revenue)

Product 3 (Quantitity sold) (Revenue)

Product 4 (Quantitity sold) (Revenue)

Out Of State

Product 1 (Quantitity sold) (Revenue)

Product 2 (Quantitity sold) (Revenue)

Product 3 (Quantitity sold) (Revenue)

Product 4 (Quantitity sold) (Revenue)

?

Thanks for any help.

It appears as if you already have a subsummary by Sales Type, so just add another subsummary by Product below it and sort by Sales Type, then Product. You don't need a body for this report, since you only want a summary of all the records, not the individual records involved. Your QuantitySold and Revenue fields will be summary fields based on each field.

  • Author

That seems to have done. Thanks!

Create an account or sign in to comment

https://fmforums.com/topic/23613-report-of-aggregate-calcs/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.