Most RecentMost ViewedMost LikesMultiple Data Models in Excel / Power Pivot It is possible to have two data models in Excel? I need to limit the data in a file that is mass customized for 32 sales people. The file needs two queries in order to be able to calculate their commissions correctly. One query looks for sales the sales person is classified as the outside rep. The other looks for them as the inside rep. Another way is to write a SQL that pulls in data where they are either the outside or inside rep. I can't figure that out. Thank you. SolvedCleaning the pivot table fields list in the data model Hi Guys as per the attached screenshot, I would appreciate your support to advise how to delete the yellow-colored duplicated Queries in excel 2013 Thank you
