Related Aggregate Reports

  • 1
  • Question
  • Updated 5 years ago
  • Answered
Within an Account details record is it possible to include an aggregated report of a related custom object?

I have a custom object called Orders (look-up relationship with Accounts)...I would like to show an orders aggregate report within an Account form

Group By (Products) Sum(Sales) Max(Invoice Date)
Product_abc $10,000 07-07-2013
Product_def $8,000 02-04-2011

thanks
Photo of rocketc

rocketc

  • 722 Points 500 badge 2x thumb

Posted 5 years ago

  • 1
Photo of Anna Wiersema

Anna Wiersema

  • 10,890 Points 10k badge 2x thumb
Yes, this is totally possible.

What you do is add an aggregate type model on your page with a condition where Account__c (the account lookup field) = a field from another model, the Account model on that page and then just select the aggregations you want and the grouping field you want and drag them all into a table component. (You can see step by step instructions with pictures in the aggregate model tutorial in that link above.)

Here's an example I whipped up on our custom Statements object. The aggregate table is on top, and you can see that it's taking statement information from the table below, & aggregating it and grouping by related Contact.



Let me know if you run into any difficulties!

You can click here for more info about creating an Account detail page using Skuid.