Forum Discussion
Resolver ISales Data with Stock Booked in Data
Hi GrahamR99,
Try function called Append Queries in Edit Mode:
Table 1Table 2Go to any Table and click Append Queries, you can select Three or more and then manually bring missing TableTables JoinedMerge 2 Region columns by selecting both, right click and select Merge columns and hit OKFinal result, now just drag and drop into your table matrix to complete
Hope this helps.
Regards
Abduvali
Skilled SharerHi GrahamR99,
Try function called Append Queries in Edit Mode:
Table 1Table 2Go to any Table and click Append Queries, you can select Three or more and then manually bring missing TableTables JoinedMerge 2 Region columns by selecting both, right click and select Merge columns and hit OKFinal result, now just drag and drop into your table matrix to complete
Hope this helps.
Regards
Abduvali
GrahamR99Hi Abduvali
That is almost it, I can't get Region and Area to display on one pivot.
This is what I have;
How do I get it like your last image?
Regards
GrahamR99