I have a portal showing a client's orders with the order's value.
Next to the order value field I have a running total summary field of all the orders' values.
The portal is sorted 'earliest to latest', the running total summary works just fine of course.
However, what I want to do is show latest to earliest with the running total summary field still showing the correct values.
I've tried just sorting the portal latest to earliest but then the summary field does not return the correct running result.
Is it possible to show a latest to earliest result and still have the summary field give the correct result?
Many thanks as always.