If you have related data stored in multiple tables, create a Data model to produce a pivot table on the combined data.
In computer term, data model refers to how each data are connected to one another and how those connections are being processed within the Sysyem