Scenario: Client needs to have a saved search to cumulate the Sales order amount separately for each location.
Solution:
List> Search> Saved Searches
Select Transactions
Enter Search Title
Criteria:
Type: Sales Order
Main line: False
Tax line: False
COGS: False
Shipping: False
Results:
Field: ID
Field: Location
Field: Amount
Field: Formula(Currency)
SUM ({amount}) OVER(PARTITION BY {location} ORDER BY {internalid} ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
Label: Cumulative Amount
Click Save