Looks like you can create a calc in your primary source:
Total Label Amt:
SUM([#]) + SUM([Data source 2].[#])
Then Display AGG([Total Label Amt]) instead of SUM([#])
that is what i have in the calculation. in order to get a correct result i have to display 'Label' column if not i will get as below
Group A = 35
Group B = 84
and Group C = 42
However, i only want Label Group in the result
Oh. I see how you got those numbers.
You have to make the blend relationship, and then in data source 2, click[Label] so that the link icon turns orange (which shows the link is connected).
In this one I have disconnected the link in Sheet 2.
Label Groups 2.twbx 13.7 KB
Got it... Thanks so much