Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Using Excel Data Models To Solve Fiscal Year Reporting In PivotTables

K2 Enterprises
5.09K subscribers
1.9K views 10 years ago
Added to the 2013 release of Excel, data models allow Excel users to link together – or relate – multiple tables for advanced analytical purposes, including serving as the data source for PivotTables. Using data models as the data source for PivotTables helps to overcome numerous issues. One of these is facilitating fiscal year reporting in PivotTables and in this tip, you will learn how you can use data models to create fiscal year reports in PivotTables. ...more
...more
Using Excel Data Models To Solve Fiscal Year Reporting In PivotTables
8Likes
1,913Views
2014Nov 25
Added to the 2013 release of Excel, data models allow Excel users to link together – or relate – multiple tables for advanced analytical purposes, including serving as the data source for PivotTables. Using data models as the data source for PivotTables helps to overcome numerous issues. One of these is facilitating fiscal year reporting in PivotTables and in this tip, you will learn how you can use data models to create fiscal year reports in PivotTables.

Follow along using the transcript.

K2 Enterprises

5.09K subscribers