I want to use flattened pivot table to get a table of two column (Branch Name , Customer Code )
My model contains 2 tables for branch and Customer and the relation is define between these 2 tables
When I drag Branch Name to row labels and then drag customer Code , I found the customer code is repeated across all branch ,
While the model describe the relation as 1 to many , the pivot table show it as Many to many relation
I need to display the data as if I wrote Branch Left join Customer , Not Branch cross join customer
Is it possible , is power pivot the correct tools ?
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?