Forum Discussion
Create sum of Expanded Table Column (number) after NestedJoin
Hi padinator
Below screenshot shows a solution. You actually don't have to expand also after join.
Table 2 column is created after merge which is shown in preview at the bottom.
Sales amount total column is created using list.sum.
Thanks,
thingsclump
Hi padinator
Below screenshot shows a solution. You actually don't have to expand also after join.
Table 2 column is created after merge which is shown in preview at the bottom.
Sales amount total column is created using list.sum.
Thanks,
thingsclump
I havr to try this out on monday because i do not merge my tables in another table but do a nested join instead where i have to ExpandTableColumn afterwards which is automatically generating x lines of Table 1 - based on the No. of Matches (n) Table 2 has with it