Forum Discussion
Releationship
Plant FP Product Description SFG Product Description FP Batch RM Batch RM Material Code RM Material description Bulk Batch Bulk Material Code Bulk Posting Date SFG Batch ...
For your reference.
Step 1: I unpivot 'Table-A'.
Step 2: I make a summarize table 'Batch Number Table'.
Batch Number Table = SUMMARIZE('Table-A','Table-A'[Batch Number])
Step 3: I add 2 relationships.
Step 4: I make 2 'Table' visuals.
Step 5: I click '50157797' of 'Table-A'.
Thanks for the response,but here we need slicers at top and we are using sankey chart for there relation of batches like Vendor>RM RM>bulk Blk>sfg,,,,as such