I have the attached table to show Target Full Year and Target YTD in Dimension 2 for test 1. I want to show a sum of the Regions to show in Dimension 1 when nothing is expanded so that the metric shows a total of all 4 regions.
Any Help would be appreciated
Also if possible on the variance column if the outcome is > than 100% then I want it to show >100% rather than the figure. is this possible.
