martinargimon
Member
HI there,
I have attached a workbook, in which i have linked two tables "tenants" and "leases", which are related via the ID field , although after creating my pivot table and trying to add the 'Last name & first name of my Tenant ( against the Lease number from the lease table) is not bringing back the correct data.
Sorry i'm a rookie still, although i find Power pivot very exciting. your comments/ help will be much appreciated.
Kind Regards
MArtin
I have attached a workbook, in which i have linked two tables "tenants" and "leases", which are related via the ID field , although after creating my pivot table and trying to add the 'Last name & first name of my Tenant ( against the Lease number from the lease table) is not bringing back the correct data.
Sorry i'm a rookie still, although i find Power pivot very exciting. your comments/ help will be much appreciated.
Kind Regards
MArtin