ownload the zipped folder nam Import the SalesRep/Region Create a DAX Measure to add Total Reven er and then import the three Excel Files into the Power Pivot Data Model. alesRep/Region Lookup Table (listed below in the sheet) into the Power Pivot Data Model. ealtionship between the two Sales Rep columns. d Cross Tabulated report that shows Total Revenue by Product and Region. Picture of what final PivotTabl Sales Rep Rudolf Eason Louetta Maloney Yulanda Mireles Timika Poe Julianna Kunz Quentin Johns Kurtis Osorio Adelina Oglesby Towanda Pemberton North America Region Asia Africa North America South America Ant Europe Australia North America North America North Americ Europ Europe Europe South America Zona Otis Ernie Pettigrew Hyman Irish Cami Goodson Evelynn Mckee Earleen Milam ownload the zipped folder nam Import the SalesRep/Region Create a DAX Measure to add Total Reven er and then import the three Excel Files into the Power Pivot Data Model. alesRep/Region Lookup Table (listed below in the sheet) into the Power Pivot Data Model. ealtionship between the two Sales Rep columns. d Cross Tabulated report that shows Total Revenue by Product and Region. Picture of what final PivotTabl Sales Rep Rudolf Eason Louetta Maloney Yulanda Mireles Timika Poe Julianna Kunz Quentin Johns Kurtis Osorio Adelina Oglesby Towanda Pemberton North America Region Asia Africa North America South America Ant Europe Australia North America North America North Americ Europ Europe Europe South America Zona Otis Ernie Pettigrew Hyman Irish Cami Goodson Evelynn Mckee Earleen Milam