Add the tooltip action that you see in the filters card in Worksheet A to 'Context' and give it a try.
I have tried making it context.
But it didnt work.
Could you attach a packaged workbook with some sample data?
I have created a fake sample dataset but was not able to recreate the issue.
And I cannot share the workbook either.
Okay. So what is the issue you're facing exactly? Could you elaborate? Also, at least some screenshots of your actual worksheets showing filters card and the view would help.
First screenshot is the one which is used as tooltip.
Here the total value for all metrics, is 31.
In the second screenshot below the above worksheet is used as tooltip.
Here the values are different that what is in the above worksheet.
I have made sure that I am seeing this for the same person.
Please let me know if I can give you any additional details on this.
Sorry but it is unclear on how the values are being calculated. Without the workbook it is difficult to guess, your best bet would be to play with filters. In your sheet B, edit the tooltip and see if you're passing <All Values> to the filter card and change it to just person name or the dimension you want it to filter by.