Hi,
I just started working with PowerPivot. I put together a few very simple tables and went to then view them in the pivot.
Table 1:
Number FirstName Last Name
123 Bill Gates
124 Paul Allen
Table 2:
Number City State
123 Mercer Island WA
124 Seattle WA
When I go to view these in the pivot, seeing something like this:
123 Bill Gates Mercer Island
Seattle
In theory, Mercer Island is also operating on the Number key 123, is there a way to get rid of the Seattle, Ideally, I'd only see:
Number FN... LN... City State
123 B... G... M... WA
124 P... A... S... WA
What am I missing here?
Thanks!
Yo
I just started working with PowerPivot. I put together a few very simple tables and went to then view them in the pivot.
Table 1:
Number FirstName Last Name
123 Bill Gates
124 Paul Allen
Table 2:
Number City State
123 Mercer Island WA
124 Seattle WA
When I go to view these in the pivot, seeing something like this:
123 Bill Gates Mercer Island
Seattle
In theory, Mercer Island is also operating on the Number key 123, is there a way to get rid of the Seattle, Ideally, I'd only see:
Number FN... LN... City State
123 B... G... M... WA
124 P... A... S... WA
What am I missing here?
Thanks!
Yo
