flattened pivot table and cross join relation

Unanswered flattened pivot table and cross join relation

  • Monday, March 18, 2013 8:23 PM
     
     

    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