Lookup Link Records with Pivot Tables/Charts

Lookup Link Records with Pivot Tables/Charts

We have a table of sales data (A) which link to a table of product data (B) via a Lookup from A accessing a unique product ID in B. How can I access parent fields in B while running reports for A?

This help document shows how to do this for List reports under the header "Creating a Link to Parent Records":
https://www.zoho.com/creator/help/forms/creating-relationship.html

But how do we do this with Pivot Tables & Pivot Charts?