computation of values in bar chart

The problem is that a single row of data can only be used in one categorical group on your axis. So you cannot count it both in your Country>category hierarchy grouping AND show it again calculated in a total bar.

One solution would to use a Waterfall Chart instead. That will allow you to have a separate sub-total bar per category. See:

I would suggest you file an enhancement request for the ability to have sub-total bars in the standard Bar Chart in the Ideas portal linked above: http://ideas.tibco.com/