Thanks for your response.
Sorry that I was not specific. I need the sum as 17881+836154 = 854135. Could you please take a look at it one more time.
It's do-able but......
Calculate g.total with table calculation is always headache because table calc itself has special formula as its feature.
So first of all, it's impossible with normal approach.
I mean you need to re-shape the data.
Then, three layers of calculations.
#3 creates duplicated numbers , then add index to narrow the view.
These table calcs are pretty much complicated and o be honest, I don't recommend that you take this approach.
I mean better calculate in different tool, then Tableau connect to new data.
Perfect. Thank you so much. Will try to modify the data as you recommended.