![]() If you have Excel 2016+ for Windows, just click the Data > Manage Data Model ribbon command as shown below: We’ll walk through these steps together:įirst, we’ll need to enable the Power Pivot add-in. Historically, we would need to use VLOOKUP or something to first combine these tables into a single table to use with a traditional PivotTable. One data table has the transactions, and another table stores the chart of accounts. Our plan is to create a PivotTable from two tables. ![]() ![]() I’ve created a video and a full narrative with all of the step-by-step details below. In this post, we are going to get warmed up by building a PivotTable from two tables.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |