Multiple values in advanced reports

Advanced reports do not support multiple values with separator in one row. If you need to use multiple values, enter each value into a separate row. All non-empty values from one column are combined and used as a filter with an OR. Different columns are used as a filter with an AND.

1. If you need to send the report to multiple users, enter each e-mail into a separate row:

   1	user1@domain.com
   2	user2@domain.com
   3	user3@domain.com

2. If you need to apply multiple values to multiple filters, add each value into a separate row. However, values from different columns can be mixed. For example,

   1. ProductID	Country
      10	USA
      11	UK

   2. ProductID	Country
      10	UK
      11	USA

   3. ProductID	Country
      10
      11
      	USA
      	UK

   The filter result will be the same for each example: filter for ProductID and Country is union, empty or null values ignored. The two columns are combined with AND. The result is: (ProductID = 10 OR ProductID = 11) and (Country = USA or Country = UK).

   It is impossible to combine different conditions like (ProductID = 10 AND Country = USA) OR (ProductID = 11 AND Country = UK).