We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

sum of last rows

Received Response
18
Views
1
Comments
edited Dec 9, 2019 12:20PM in Reporting & Analytics for B2C Service 1 comment

Summary

How to get the sums of the last rows from one or several tables?

Content

Hello,

I have a challenge for the reporting experts around here :-)

I have several custom objects with, in essence, these fields:

Object A:
- person
- date
- amount

Object B:
- person
- date
- amount

There can be several rows for a given person and a given date, with different amounts.

I need a report that would display this:
1 - person
2 - from object A: last date for this person
3 - from object A: sum of the amounts for this person and this last date
4 - from object B: last date for this person
5 - from object B: sum of the amounts for this person and this last date

There

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!