I hope I understood the request correctly...
Below is final view.
Duplicate the data soure
Select all and remove
Add Person Id 1 and Person Id 2 relationship
Initially showing above strange relation , but hit OK and then edit
in detasource 1
sum([Number of Records])+SUM([data(copy)].[Number of Records])
personid1,2_9.0.twbx 21.3 KB
Thank you for the quick response. But in data source TTL formula is not working. It is showing that there is some problem with the syntax. Please let me know if there is any other way.
I don't know other way at this point.
What's the error?
Could you send me a screen shots?