Forum Discussion
Pivot table from 2 sets of data
Hi everyone, I need to analyse 2 sets of raw data. One is related to inbound stock and the otherone to outbound. Each set of data is in a separate sheet of the workbook. The columns on each set of d...
Hi Martin_Weiss, thank you very much for your reply.
Would you mind telling me how to automate the bridge table? I have never used the tools you mentioned.
Also, in the set of data, there where a few items without an item code (it is blank), so, when creating the bridge table and later linking it with the other tables, I wasn't able to get those items in blank (and I need to show them on my pivot table). Would you know how to solve this?
As variant you may build virtual relationship. As an example, for such model
measures are
Total In:=SUM( 'In'[In] )
Total Out:=CALCULATE( SUM( Out[Out] ), TREATAS( VALUES('In'[Code]), Out[Code] ) )Virtual relationship affects performance, but that's on relatively large datasets. Within Excel that usually not an issue.
