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 ?
khaled Mohamed