Pivot table total for Year and region for each column
I have a case for pivot table where I have Targets for country in my file. Now I got additionally targets for region year-wise as well as for particular year as well. Now when I am adding Target column in pivot table it is showing me targets against country keeping Region and Year total field blank as per attached screenshot.
Now my question is how I can show the targets for Year and Region (these are fixed targets).