Instructions: Submit $(2)$ completed XLS files in D$2$L: Assessments$>$ Assignment $8$

TASK: You want to count the number of products sold by each reseller and the number of products for each business type by using a Pivot Table. From the Adventure works database, you will use three tables: DimProduct, DimReseller, and FactResellerSales.

Save your name to the filename $-$ Assignment$8\_$Excel$\_$DataFile$\_$YourName.xls

Using VLOOKUPS, create a single table that contains the information that you need to complete the task above: Business Type, Reseller Name, & ProductName.

Create a Pivot table based on this table to count the number of products for each business type and the number of resellers for each business type.

$\backslash$table$[[$Row Labels,Count of Product$],[$ Specialty Bike Shop,$7,987$