There are so many post discussing how to add column to sales order grid, but no one discussed about HOW TO ADD COLUMN TO Order Total Report GRID (REPORTS > Customers > Order Total) and display custom customer data to new column in magento2? Can someone tell me how to do that?


Try following way to add customer email to that grid:


<?xml version="1.0"?>
<page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd">
        <referenceBlock name="adminhtml.report.grid.columnSet">
            <block class="Magento\Backend\Block\Widget\Grid\Column" name="adminhtml.report.grid.columnSet.customer_email" as="email">
                    <argument name="header" xsi:type="string" translate="true">Email</argument>
                    <argument name="sortable" xsi:type="string">0</argument>
                    <argument name="type" xsi:type="string">text</argument>
                    <argument name="index" xsi:type="string">customer_email</argument>
                    <argument name="id" xsi:type="string">customer_email</argument>
                    <argument name="column_css_class" xsi:type="string">col-name</argument>
                    <argument name="header_css_class" xsi:type="string">col-name</argument>
  • how to display custom customer attribute value to newly added column? It's showing new column 'Affiliate ID' but not displaying value of custom attribute.
    – Prince FB
    Feb 14 '19 at 6:48
  • What do you mean by customer attribute? Check sales_order table column.
    – Sohel Rana
    Feb 14 '19 at 6:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.