With custom reports, you can change the dimensions, columns and filters that you'd like to use. This view will open up when you are editing a report, and select Manage on either Dimensions or Columns.
You can also see this when you choose Edit Columns in the report (remembering this is only valid for this view, but on refresh the next visit of this report). There are 2 views, a basic and an advanced.
This will show you a list of simple attributes/columns you can add related to the order.
This will list all available tables from the database to make your report. Use this if you can't find the attribute on the Basic View.
You can swap between views by selecting the button next to the search bar.
Adding additional columns
Go to your Edit Report section (3 bars from the top right of your custom report)
Go to either Dimension or Columns (depending what you want add) and choose Manage.
On the pop up, scan through the available fields from the left and simply click on it so it will add it to your existing columns to the right.
You can also move these around to rearrange the order in the report.
If you cannot find the column that you are after - simply press toggle into Advanced View to see all of the columns on the marketplace.
Common Attributes to search for in Advanced View
There are a few attributes that you may want to use in Advanced View that you cannot find in Basic. We've listed a few commonly used attributes that you can add to your columns or dimensions.
Shows the Vendor ID of the Vendor on that order
Shows the Vendor ID of the Vendor on that quote
Displays the name of the Vendor (use this to match the ID of the Vendor is using ID as Dimensions)
Display's the product's SKU - Use this for Dimensions to split order into different product rows.
Display's the individual products - use this when SKU is the individual
Displays all the products for that order (use when Vendor ID is the dimension to show the products specific for this vendor).
Order Items > Base Row Total Incl Tax
Shows the subtotal for the individual item if using catalog_product_entity|name as a separator