I'm trying to write the condition which qualifies to show the value only for the dimension "Dim 3". I tried using dimensionality function to restrict but when we swap the "Dim 3" to the initial position then it doesn't satisfy our requirement.
Below is the detail,
I have loaded the application with the sample data, in the below snap Column 1 and Column 2 values must display the value only for "Dim 3". Instead of totals, I have coded it has as white space for a look and feel.
When I swap the "Dim3" to the 1st dimension then the values don't group for "Dim3",
I have attached the sample application, loaded with the manual input data. Feel free to include the field in the back end if necessary.