In the end, the file is imported to the data model and click on finish.Also, if you want the top column to be the header row, tick mark the option “Use the first row as column header” and hit Next.Click on Browse to choose a path to your data file. Here you can rename the connection from the default name “Excel”.Scroll to the end to get the option of Excel File and click Next. Now you will again get a dialogue box opened.So follow the steps and screenshots and click on “From Other Sources”. Here you will find multiple options and sources available to upload the data.Here you will get a window opened, which surely will be blank in case this is the first time you are importing the data.After that go to the Data model and click on the Manage button.As said earlier, first of all, make sure that the Power Pivot tab is enabled.If you cannot find the tab, check out this tutorial. Make sure that you got the Power Pivot tab in your ribbon. Here comes the most powerful method to identify the unique entries Power Pivot. Boom!! The Pivot Table is ready with unique entries in each Pivot Table.Here you need to add Location to the ROWS and Count No to the values.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |