SAC Calculate after aggregation based on datasphere

[Charlielin]

Dear Expert,

   I am trying to calculate the difference of GP% between current year and last year. But the formula behave kind of weird. Here is our sample data:

We have calculated the GP% for 2024/08 and 2024/07 in the Analytic Model of Datasphere and it worked just fine(Green). But when it come to SAC story to calculate difference of 2 years, instead of simply minus one from the other, it seem to firstly calculate the difference of each SALES/COST/GP(Orange) and then calculate GP/SALES(Red) which is wrong. What we need is the calculation after aggregation which is just simply 0.42 - 0.37. 

Any suggestion?

We are using live connection from SAC to Datasphere, I've tried to create calculated measures both in the view and analytic model but neither of them worked. 

Appendix 1: Using Exception Aggregation for all fields in the Analytic Model

[XaviPolo]

As you need a calculation AFTER aggregation, it must be done in SAC or in Analytic Model.

Create a Restricted Measure in the Analytics Model for CY and LY, and then create a Calculated Measure with the CY - LY, this will be calculated AFTER aggregation and tranlated as

AGG(X) WHERE CY  - AGG(X) WHERE PY

Regards,