Hi All,
I want to know if it is possible to create a report that displays the sum amount of orders but considers only the max transaction for each category (custom field).
For example:
For customer ABC, the max SO for category A is 30, and for category B is 100. Then the sum will be 130.
This is the expected results:
Thanks,