Thanks to Colin Michael and Alejandro Quiceno for suggesting Power Pivot in general. In this simple example, it will get the relationship correct. Excel 2010 will attempt to AutoDetect relationships first. When it comes time to create relationships, you have only one button called Create. Choose Create Linked Table.įrom either the PowerPivot tab in the Excel ribbon or the Home tab in the PowerPivot ribbon, choose to create a pivot table. If Excel leaves you in the PowerPivot grid, use Alt + Tab to get back to Excel. ![]() On the PowerPivot tab, choose Create Linked Table. Once you have that installed, here are the extra steps to get your data into Power Pivot: To join two tables in Excel 2010, you have to download the free Power Pivot add-in from Microsoft. This was very hard to do in regular pivot tables. Because the pivot table is based on the Data Model, you now have Distinct Count.Īfter you select Distinct Count, the pivot table shows a distinct count of customers for each sector. ![]() ![]() ![]() At first, the Summarize Values By looks like the same Sum, Average, and Count that you’ve always had. Select a cell in the Count of Customer column.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |