Aug 06 2019 06:45 AM
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.
Aug 06 2019 06:53 AM
Aug 06 2019 06:55 AM
Thank you but that brings in all sales reps into the data model and we need to limit the data to the specific rep: too many rows and we don't want them seeing other reps data.
Aug 06 2019 07:07 AM
Aug 06 2019 07:11 AM
Hi,
There are tow fields: Inside Rep, Outside rep. I need all data where the report rep is either of those.
Aug 06 2019 08:25 AM
Aug 07 2019 08:16 AM
SolutionI figured out the SQL. Interesting thing is that you can't place in the Where clause items that are in the Select clause. That was the issue.
Aug 07 2019 08:23 AM
Aug 07 2019 08:16 AM
SolutionI figured out the SQL. Interesting thing is that you can't place in the Where clause items that are in the Select clause. That was the issue.