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
edited Dec 9, 2019 12:20PM in Reporting & Analytics for B2C Service 1 comment


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



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


Howdy, Stranger!

Log In

To view full details, sign in.


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