For starters, what exactly is the data model? The data model provides a way to organize tables and formulas that can be used in a PivotTable. Overviewīefore we get too far, let’s jump up to 30,000 feet. If you’d like to learn how to build a PivotTable using the data model, and learn what the data model is, strap in…this will be a fun post. Many of the typical restrictions are removed when you use the data model rather than a single Excel table. Traditional PivotTables are an incredible feature of Excel, but, they are not without limits.
0 Comments
Leave a Reply. |