Address Field Filters
It's important to note that when you filter by address fields in reports, a record can have many address rows. Rollups may include duplicates, leading to incorrect column totals. For example, if you filter customers by state, each customer may have multiple addresses that met the filter criteria, and duplicates could lead to incorrect column totals.
To avoid this issue, you need to use a more specific filter, for example:
-
Filter based on the customer's default billing or shipping address and state, instead of only state. (Customer/Job>Address Book>Default Billing or Default Shipping, + State)
-
Filter based on the sales transaction's billing or shipping address and state. (Sales>Address>Billing Address State or Shipping Address State)
Either of these options returns one address and shows the correct amount for the customer.