The values that are displayed are correct, split by Q1 OP. But the same chart with the dimension Q1 shows incorrect values. Shouldn't the chart with dimension Q1 display the same values as Q1 OP but added up?
Basically, you were only showing Q1, but you really wanted to perform the calculation at the Q1 OP level and then add it up... So, in order to do that you can use Aggr() function... which create a virtual table where there are two dimensions Q1 and Q1 OP and perform the calculation with both dimensions. And later Sum() function just sums up all the values of all Q1 OP within the Q1.
Second part, was the TOTAL qualifier. Here we needed to add <Q1> because when you performed the calculation... it seems that you only had selected a single Q1.... which is why you saw the total for Q106_7. But if nothing was selected... it would have showed overall total... in order to make the total for each Q1, I added TOTAL <Q1>.