Zoho Analytics Pivot Table

Zoho Analytics Pivot Table

We are trying to generate a sale analysis reports for all the customers in Zoho Analytics 

Format of Report:
<Customer Name><Invoice Numbers><Items>

But when we are generating the report, we are taking base table as invoices.

We can see only customer ID in pivot table instead of Customer Display names.

How can we show customer name instead of customer id in reports?