When looking at results by a certain dimension, one or more of the lines may have no content:

This behavior may be expected, or you can use Analytics to improve the reporting output if needed.

Matrix reporting

In Analytics, you can report on items by matrix to gather sizes and colors into one style. If the items are not matrix items, their relative matrix is expected to be null.

Additionally, some fields may not need any definition:

• Not all Sales Lines will have Discount descriptions
• Not all Customers will have a Title or Type
• Not all Order will have a Received date

Items or Customers reporting

Items or Customers fields may not fully filled out due to:

• Items created without Categories or Vendors.
• Sales not having identified Customers.
• Customers without addresses.

You can filter Analytics reports to look at the null instances and then add another dimension to extract the data. Let's say there's a null Top Level Category in the results:

Add the Top Level Category as a filter:

Then filter for Top Level Category is null:

Add in an identifier dimension, like Description or System ID:

Run to get a list of the Items that may need action in Retail: