Using Lookup Relationships in Pivot Tables

The same relationships can be used when creating Pivot or Summary tables.

(See our course on Pivot and Summary tables if needed)

Select the Account Type (Accounts module), Username (Users), Deal name (Deals), expected revenue (Deals).

This Pivot table, built on 3 different tables using lookup columns, now gives us a very organized look at the data!