In my app, I have a view that shows a list of related things with an aggregate to SUM the Quantity column of those fields.
Here is my issue, My view only shows 5 in-lines rows and now my aggregate only does a SUM on those 5 instead of all related rows.
I know the obvious fix is to increase my in-line rows to 10 or 100. Not an option in this instance. I need it kept at 5.
Is there a work around or another option?