Forum Discussion
Solved
Multiple 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...
I 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.
I 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.
If I'm not sure about the syntax of a query I tend to use MSAccess' querydesigner to build the query.