I am a beginner in Tableau and struck with below issue in computing a value of a specific cell where I need to validate a condition and if TRUE perform a subtraction. There are several countries which has default value of which I need to "compute a new value" only for Asia Pacific by subtracting the value of China.
My chart when moved in to rows / column panel should display only the computed value for Asia Pacific and default value for China & other countries.
Note: I tried using "Table calculation" by selecting Calculation Type = "Difference from" and Compute Using = "Specific dimension which is " Region" and Relative to = " China", which considered all other countries in the report against China but I need only "Asia Pacific" to display the computed value.
Refer attachment for query in detail.
