If I am getting you correct- create a calculated field (total)- which will be a sum of all the region/division values. I guess that would do it.
Can you attach a sample workbook with Superstore data to help u?
Below is the link of the Sample Workbook:
Here I have kept only three sub-categories but I want total of all the sub-category divided by Years. I have also pasted below the screenshot of actual OBIEE report that I want to migrate into Tableau:
Could you please provide a solution for the above problem?
Thanks in advance!