You can use data from the tables which are linked to get Net,Cost, Trnamt and then since fourth value is Constant, just use actual value and get your Result.
The Total on the analytics tab is not actually adding the numbers in your viz (like an excel spreadsheet) It is looking at the underlying table and applying and doing the calculation there -
That is a way of saying there are not unique values that are totals - so what can you do - it you can use LOD's in with your data (you didn't attach your workbook so we can't see them ) then you can use that when you create your worksheet
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.