Exporting Data for PivotTable Analysis

Dynamic PivotTables provide a way to slice and dice your data in different ways to quickly discover patterns.

Task: Exporting a Dynamic PivotTable

By default, all the columns in a view will be available to use in a PivotTable. If you want more columns, you can either add them to your view before you export or click the Select Columns button.

When you open the exported file, you’ll see your standard blank PivotTable, ready to select the data to pivot. To select the data to pivot, do the following:

1. In the security message, click Options to enable viewing the content.

2. On the Data tab, click Refresh from CRM.

You are now ready to explore your data by using the PivotTable.

Two sheets are created for each ...

Get Sams Teach Yourself Microsoft® Dynamics CRM 2011 in 24 Hours now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.