I
Ixtreme
I have a database with transactions for each customer (based on unique
Client Identifier) with a Data Dump Date field to represent the
transaction date.
For each customer I would like to sum the field Base Amount for the
current month and compare that amount with the previous month totals
for that customer. If the current month total is greater than the
average total amount for the customer, I want all the individual
transactions for that customer for the current month to be displayed.
Client Identifier) with a Data Dump Date field to represent the
transaction date.
For each customer I would like to sum the field Base Amount for the
current month and compare that amount with the previous month totals
for that customer. If the current month total is greater than the
average total amount for the customer, I want all the individual
transactions for that customer for the current month to be displayed.